headermask image

Business Tools Blog

REPT function to create instant bar chart

REPT or repeat can save time when typing a large string of numbers. 

Example:

Rather than typing “—————————-”

use the formula =REPT(”-”,20) (formula displays “-” 20 times)

This YouTube clip shows REPT function being used to create an instant bar chart.  It’s a pretty cool idea. Since the repeat function is limited to 32,767 characters, you may need to divide by 100,000 to compare customer revenue.  To compare % you could multiple by 100.  Watch the 1:33 minute video to see how easy REPT is to use.

 

If you liked my post, feel free to subscribe to my rss feeds

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*