Microsoft Office Tutorials and References
In Depth Information
Creating a Text Chart Directly in a Range
The example in Figure 133-3 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 which appears as a small n,
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 133-3: 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 might 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