Gauges

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.