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

chart.

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:

=REPT(“*”,24-LEN(A1))&A1