Creating a gauge chart

Excel 2016 2013 2010 2007 2003
A gauge, dial, or speedometer chart displays a value between 0 and 100%. Where the Goal is 100%, and the displayed value is a fraction of the Goal. The actual value can be displayed as a percentage or as a number:
The gauge Chart in Excel 365

Use elements of pie or donut (doughnut) chart types to create a gauge chart. In some cases, add a pointer to indicate a value - see more about how to create a speedometer chart.

The gauge chart above displays a single value (in cell C14) against a Goal of 100%. Cell C14 contains a formula that calculates the percent of the Goal:

= C12 / C11

Three data points (in this example, cells D11:D13) are used to create a gauge chart:

  • Cell D11 consists of 50%, and that slice is hidden,
  • Cell D12 contains the formula to calculate the value in percentage of the Goal:

    = MIN (C14, 100%) / 2.

    The MIN () function displays the smaller of two values: the value in cell C14 or 100%. The result is divided by 2 because it only deals with the visible half of the pie chart. The MIN () function prevents the chart from displaying more than 100%.

  • Cell D13 contains the formula that calculates the remaining part of the pie:

    = D11 - D12.

As you enter new data in column C, the formulas display the current results:

The gauge Chart in Excel 365

To create a chart like the one above, do the following:

Create a simple pie chart

   1.   Select the cells with your data (for this example, D11:D13).

   2.   On the Insert tab, in the Charts group, click the Insert Pie or Doughnut Chart button:

Pie Chart in Excel 365

From the Insert Pie or Doughnut Chart dropdown list, choose the Pie chart:

Pie chart in Excel 365

Excel creates a simple pie chart:

The simple pie chart in Excel 365

Format the chart

   3.   Optionally, remove the chart title and legend.

Rotate the pie chart

   4.   Right-click on the data series and choose Format Data Series... in the popup menu:

Format data series in popup menu Excel 365

   5.   On the Format Data Series pane, in the Series Options tab, change the Angle of first slice setting:

Series Options in Excel 365

For this example, choose or type 90%.

Hide the unneeded data point

   6.   Double-click on the data point you want to hide to select it instead of selecting the data series.

In this example, double-click on the slice of 50%.

   7.   Right-click on the selection and choose Format Data Point... in the popup menu:

Format Data Point in popup menu Excel 365

   8.   On the Format Data Point pane, on the Fill & Line tab:

  • In the Fill section, select No fill,
  • In the Border section, select No Line:
Series Options in Excel 365

Format visible data points

   9.   Do one of the following:

  • Double-click twice on the data point you want to format,
  • Hold the Ctrl key and use the arrow buttons to select the chart element you need.

If needed, right-click on the selection and choose Format Data Point... in the popup menu.

   10.   On the Format Data Point pane, on the Fill & Line tab, select the appropriate filling option for each data point.

See more about different filling options.

You can then make any other adjustments to get the look you desire.

See also How to create dependent on a volume chart title.

See also this tip in French: Comment créer un graphique en jauge simple.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.