Microsoft Excel Tutorials | The World of Tutorials | Microsoft Excel Macros Tutorials: REPT Function

Showing posts with label REPT Function. Show all posts

Sunday, October 30, 2011

Use the REPT function to show data in a chart - Text Functions - Microsoft Excel Tutorials

Use the REPT function to show data in a chart in 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->.