A gauge can be displayed in a report to give a visual representation of the scale of a value. To insert a gauge, select a cell and click the Insert Gauge icon. The Gauge Wizard will appear. The Gauge Wizard has two tabs: Appearance and Data.
Appearance
Select the type and size of the gauge.
Data
Use the Value and Range list to select the cell which contains the numeric values for the gauge. Use the Provide range as buttons to specify if the Min and Max values for the Gauge should be static numbers or come from cells on the report.
In the Color Ranges, use the Color By buttons to specify if
color ranges should be percentages of the Max value, static numbers, or come
from cells on the report. Set the colors by entering hex values, or selecting a
color from the picker.