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.