Microsoft Office Tutorials and References
In Depth Information
Creating a gauge chart
Set the Gap width to 0 (this makes the column occupy the entire width of
the plot area).
In the Format Axis dialog select Scale tab, set the Minimum to 0 and the
Maximum to 1.
Figure 8-8: This chart displays progress toward a goal.
Figure 8-9 shows a variation on this theme. In this case, the chart is a line chart,
with a single data point. The series marker has been replaced by an AutoShape in
the form of a double-headed arrow.
Refer to Chapter 6 for more information about copying AutoShapes and
pasting them as series markers.
Creating a gauge chart
Figure 8-10 shows a pie chart set up to resemble a gauge. Although this chart
displays a single value (entered in cell B1), it actually uses three data points (in
A4:A6).
One slice of the pie — the slice at the bottom — always consists of 50%, and that
slice is hidden (the slice’s Area and Border were set to None). The other two slices
are apportioned based on the value in B1. The formula in cell B4 is
=MIN(B1,100%)/2
Search JabSto ::




Custom Search