The default gauge chart uses a band divided into thirds that runs from green to red. You can change the properties to improve the presentation of your data. For example, you may want change the colors in the band or you may want to use a number instead of a percentage as a threshold.
Open the gauge chart.
Click the chart object.
In the Color & Background section of the Properties pane, double-click the Gauge Palette property.
Specify the following properties:
To change the color of a palette entry, under Palette, select the color, click Color, specify the color properties, and click OK.
To change the boundary value of a palette entry, under Palette, select the boundary value, and specify the color properties, and click OK.
To define a new palette entry, click the
new palette entry button .
To choose a threshold style, set the Palette property.
You can choose whether to use discrete colors or continuous colors.
To use a number instead of a percentage as a boundary, click a number under Palette, clear the Percentage check box, and then type a number in the Numeric boundary box.
To copy and paste a gauge palette, open the gauge palette dialog box and click the copy button to copy the palette to the clipboard. Close the palette dialog box. Select another chart, open the palette dialog box, and click the paste button to paste the palette from the clipboard.