Bar Chart using REPT function

The REPT function repeats text a given number of times. For example, =REPT(“*”,10) repeats * 10 times in a cell.

You can use this function to create a simple bar for values in multiple cells. Here is a short video on YouTube:

This entry was posted on Monday, August 4th, 2008 at 12:48 pm and is filed under Blog, Charting, Functions & Formulas. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

You must be logged in to post a comment.

Excel Blog