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

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.

Show and Format Labels

When Visualization builds a Gauge chart, the data labels and show percentage values are not displayed by default on the chart view.

To view data labels and the percentage value

  • In the Color Deck, hold down the CTRL key and select Product Category, and then place it in the Label Deck. 

Visual Analytics shows product categories with their profit values below the gauge chart.

To format data labels

  1. Open Label Deck.
  2. In the Data Label Color area, keep foreground to Automatic and change the background to match needle colors.

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


Other actions that you can perform on a plotted gauge chart are as follows:

  • You can customize the foreground and background color for all labels. For more information, see Label Appearance. 
  • 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.  


  • No labels