Microsoft Office Tutorials and References
In Depth Information
Figure 5-4: Using the REPT function to create a histogram in a worksheet range.
Assign the Wingdings 2 font to cells D2 and then copy the formulas down the column to accommodate all the
data. Depending on the numerical range of your data, you may need to change the scaling. Experiment by repla-
cing the 100 value in the formulas. You can substitute any character you like produce a different character in the
The workbook shown in Figure 5-4, text histogram.xlsx, is available at this book's web-
site and contains another example of this technique.
Padding a number
You're probably familiar with a common security measure (frequently used on printed checks) in which num-
bers are padded with asterisks on the right. The following formula displays the value in cell A1, along with
enough asterisks to make 24 characters total:
=(A1 & REPT(“*”,24-LEN(A1)))
Or if you'd prefer to pad the number with asterisks on the left, use this formula: