Speedometer Chart in Excel

speedometer chart is a combination of donut and pie chart. The chart looks like this:

To create a speedometer chart:

1. Highlight a range H2:I6.
2. On the Advanced tab Insert (Insert) in section Diagrams (Charts) click All diagrams (Other Charts) and select Annular (Doughnut).
3. Next, you need to select each data point and use the command Selection Format (Format selection) adjust the fill of each element. Pay attention to the example shown below:
   • For a series of dataDonut» The fill is set up as follows: the first three sectors have a different fill color (red, yellow and light green), and the fourth dot has no fill.
   • For a series of dataFloor» – the first and third points are not filled, and the second (smallest sector) is filled with black.

   Data Series “Donut” or “Floor» can be selected on the tab Framework (Format). You can use the arrow keys to move from one data point to another.

   

4. Select a series of data “Donut”, press the button Selection Format (Format Selection) and enter for the parameter Rotation angle of the first sector (Angle) value 270 degrees.
5. Select the diagram, right-click on it, in the context menu, click Chart Area Format (Format Chart Area) and for the fill and border options, select respectively No fill (Not son) и no lines (No line).
6. Delete the legend. Result:
7. Select a series of data “Floor‘ and change the chart type for this series to Circular (Pie).
8. Select a series of data “Floor”, press the button Selection Format (Format selection), for parameter Angle of rotation of the first sectors (Angle) enter a value of 270 degrees and select the series construction mode minor axis (secondary axis).Result. Data Series Plot “Floor” comprises:
   • invisible colorless sector corresponding to the value 75,
   • black sector-arrow corresponding to the value 1
   • and another colorless sector corresponding to the value 124.

   

9. Using the control Counter (Spin button) change cell value I3 from 75 to 76. On the graph of the data series “Floor» changes will occur: the first colorless sector will reflect the value 76; the second black will remain equal to 1; the third colorless sector will show the value 200-1-76=123. Thanks to the formula in the cell I3 the sum of these three sectors will always be 200.