Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

Image RemovedImage Added

Info

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

...

  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 Image Removed the Image Added tab and then click Image RemovedImage Added. Visualization builds a Gauge Chart.
    Image RemovedImage Added

    Visualization builds separate Gauge charts for each category.
    Image RemovedImage Added

  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.

    Image RemovedImage Added

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. 
    Image RemovedImage Added

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

To format data labels

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

Change the Color Range

...

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

    Image RemovedImage Added

Change the Threshold Value

...

  1. In the Chart Properties area, click Options
    Image RemovedImage Added
  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.
    Image RemovedImage Added

Other Actions


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

...