USE THE REPT FUNCTION TO SHOW DATA IN A CHART USING MICROSOFT EXCEL

To show data in a chart-like view (Showing Percentage of Progress in graphical form in Excel Cell), you can define a character and repeat this character a specified number of times using the REPT text function in Microsoft Excel.

To show data in a chart:

1. In cells B2:B10, type percentages in the range of 1% to 100%.
2. Select cells C2:C10 and type the following formula: =REPT("|",B2*100).
3. Press <-Ctrl+Enter->.