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.
Search JabSto ::




Custom Search