Microsoft Office Tutorials and References

In Depth Information

**A gauge chart**

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 percent. It then divides this value by 2 because only the top half of the pie is relevant. Using the

MIN function prevents 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.