This nifty little Excel tip comes via LifeHacker.com, originally given by JuiceAnalytics. You can create a sweet little bar meter chart by using the REPT() function. REPT is short for repeat. Here’s how:
- Format the cells you want to show your meters in as Arial, 8 pt to give it a tight look.
- Here’s a screen shot of some data and the formula:
- Copy the formula down through you data list, and voila! You have a nice little bar chart.
The magic is in the REPT, which takes 2 arguments: 1) what to repeat, 2) how many times. =REPT(“X”, 5) yields: XXXXX
Simple, yet effective.