Microsoft Office Tutorials and References

In Depth Information

Figure 17-6:
This chart resembles a speedometer gauge and displays a value between 0 and 100 percent.

One slice of the pie — the slice at the bottom — always consists of 50 percent. I rotated the pie so that the 50

percent slice was at the bottom. Then I hid that slice, by specifying No Fill and No Border for the data point.

The other two slices are apportioned based on the value in cell B1. The formula in cell B4 is

=MIN(B1,100%)/2

This formula uses the MIN function to display the smaller of two values: either the value in cell B1 or 100 per-

cent. It then divides this value by 2 because only the top half of the pie is relevant. Using the MIN function pre-

vents the chart from displaying more than 100 percent.

The formula in cell A5 simply calculates the remaining part of the pie — the part to the right of the gauge's

“needle”:

=50%–A4

The chart's title (Percent Completed) was moved below the half-pie. A linked text box displays the percent

completed value in cell B1.

Displaying conditional colors in a column chart