A gauge chart, also known as a speedometer chart is often used to highlight key performance indicators for a business. Gauge charts use a radial scale to display the data range and use needles to map numerical values against a default color range of red, yellow and green. As an example, business executives can use this chart to get a birds-eye-view on the profitability per product line. The number of needles on your chart depends on the number of categories you are evaluating.

Download and connect to the sample data source. We are making this chart using 2 dimensions and 1 measure.

Contents

• Build a Gauge Chart
• Change the Color Range
• Change the Threshold Value
• Other Actions

Build a Gauge Chart

To build a Gauge chart

1. Connect to the sample data source in Aqua Data Studio.
2. From the Dimensions pane, click Product Category, and State.
3. From the Measures pane, click Profit.
4. Click the  tab and then click . Visualization builds a Gauge Chart.
   
   

   Visualization builds separate Gauge charts for each category.
   

5. From the Columns Deck, drag Product Category to the Color Deck.
6. From the Rows Deck, drag State to the Break Deck.
7. Filter Product Category and State as desired.
   

   

Change the Color Range

To change the default color range

1. In the Chart Properties area, click Options. 
2. Click any color and then from the Color Palette, select the desired color.

   

Change the Threshold Value

To change the default threshold value

1. In the Chart Properties area, click Options. 
   
2. In the text box under Green, type 10000, and then Press Enter.
   In the text box under Red, type 5000, and then Press Enter.
   

Other Actions

• You can sort data by using various sort options available in the chart view or the Advanced dialog. For more information, see Sorting.
• You can use highlight actions to focus on selected needles. Visual Analytics makes the highlighted needles and its data labels prominent while dimming others in the view. For more information, see Highlight Actions.
• You can filter records directly from the chart view without manually adding any fields to the Filters Deck. For more information, see Filters.
• You can export worksheets containing visualization to Image, HTML, and PDF formats. For more information, see Export Visualizations.