Use the REPT function to create quick charts

Wouldn't it be great if you didn't have to embed a chart in a spreadsheet to get a graphical comparison?

You can, by using Excel's REPT (REPeaT) funtion.

Here is an example from ZDNET Asia. It's just part of the article, so scroll down a little.

To keep employees informed of their progress, you might keep a worksheet like the one inFigure A, which tracks the completion rates of assigned tasks.

Figure A 

Just listing the completion rates, however, makes it hard to compare one task with another. It's easier to monitor results when they are presented graphically. Follow these steps.

1. Select D2:C11.
2. Enter the following formula (Figure B):
   =REPT("|",C2*100)

Figure B 

3. Press Ctrl + Enter.

The comparative results are now shown graphically, as shown in Figure C.

Figure C 

(Note that you can use any symbol for "|" in the formula. )