Excel: Make a bar meter graph in a cell using REPT

Posted on Thursday, July 26th, 2007. Filed under Microsoft Excel.

Excel in-cell bar chartThis 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:

  1. Format the cells you want to show your meters in as Arial, 8 pt to give it a tight look.
  2. Here’s a screen shot of some data and the formula:Excel in-cell bar chart
  3. 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.

Share and Enjoy:
  • Digg
  • del.icio.us
  • Slashdot
  • SphereIt
  • StumbleUpon
  • Technorati
  • YahooMyWeb
  • Google
  • Live
Sphere: Related Content



You can now:

Leave A Comment (0). Or, Leave A Trackback. Or, view Comments Feed.

Previous Post: SAP-TIP: View All Recurring Entry Documents »
Next Post: SAP: PCA Roll-forward Problem with 1KE8 Doc Transfers »

Related Reading:


Subscribe without commenting


Leave a Reply

Note: Any comments are permitted only because the site owner is letting you post, and any comments will be removed for any reason at the absolute discretion of the site owner.

You must be logged in to post a comment.

Latest Posts: