Gauge

A gauge will show a progress bar as determined by a percentage. The percentage is calculated from the lower-based value of your data against a range, as determined by the start and end values.

Example 1

If the Excel data cell used for the metric link is 0.87 (or 87%), the start value is set to 0 and the end value is set to 1, the gauge will display 87%.

Example 2

If the Excel data cell is 0.87, the start value is 0.8 and the end value 1.0, the gauge will display 35%.

Note: Select or deselect Display Percentage Value to display or hide the actual percentage figure on the gauge.