Microsoft Office Tutorials and References
In Depth Information
Using formulas to display repeating characters
The example in Figure 94-4 uses formulas in columns F and H to graphically depict monthly budget
variances by displaying a series of characters. You can then easily see which budget items are under
or over budget. This pseudo bar chart uses the character n , which appears as a small square in the
Wingdings font.
The key formulas are
F3: =IF(D3<0,REPT(“n”,-ROUND(D3*100,0)),””)
G3: =A3
H3: =IF(D3>0,REPT(“n”,-ROUND(D3*-100,0)),””)
Figure 94-4: Displaying monthly budget variances by using the REPT function.
For this example, follow these steps to set up the bar chart after entering the preceding formulas:
1. Assign the Wingdings font to cells F3 and H3.
2. Copy the formulas down columns F, G, and H to accommodate all the data.
3. Right-align the text in column E and adjust any other formatting.
Depending on the numerical range of your data, you may need to change the scaling. Experiment by
replacing the 100 value in the formulas. You can substitute any character you like for the n in the
formulas to produce a different character in the chart.
Search JabSto ::

Custom Search