Microsoft Office Tutorials and References
In Depth Information
Using formulas to display repeating characters
To add data bars to a range, select the range and choose Home
➜
Conditional Formatting
➜
Data Bars
and select one of the fill options.
Excel provides quick access to 12 data bar styles via Home
➜
Styles
➜
Conditional Formatting
➜
Data
Bars. For additional choices, click the More Rules option, which displays the New Formatting Rule
dialog box. Use this dialog box to do the following:
➤ Show the bar only (hide the numbers).
➤ Specify Minimum and Maximum values for the scaling.
➤ Change the appearance of the bars.
➤ Specify how negative values and the axis are handled.
➤ Specify the direction of the bars.
Using formulas to display repeating characters
Figure 94-2 shows an example of a chart created by using formulas.
Figure 94-2:
A histogram created directly in a range of cells.
Column D contains formulas that incorporate the rarely used REPT function, which repeats a text
string a specified number of times. For example, the following formula displays five asterisks:
=REPT(“*”,5)
In the example shown in Figure 94-2, cell D3 contains this formula, which was copied down the column:
=REPT(“*”,C3/2)
