Finally right click the wedge on the bottom and choose Format Data Series. Next, change the doughnut Hole Size to 50%. First, change the Angle for first slice by typing in the number 270 and pressing Enter. We’ll make two changes in the next dialog box. Right click the chart and choose Format Data Series.
For this activity, it’s best to create the chart in the same worksheet as the data to make all the necessary modifications easier. Note: While you can use the F11 shortcut to create a chart. In later version, you’ll find it in the drop down button for Pie Charts. You’ll find this in Excel 2010 on the drop down button named Other Charts. Select the 7 cells for your Speedometer and insert a Doughnut Chart.
We’ll need all 7 cells, including the total. In the sample file, we’ve set up 6 intervals which add up to 180. The number and value of intervals depends upon how detailed you want to be. If a circle is 360 degrees, then a half-circle is 180. In this tutorial, you’ll learn how to create this snazzy image from a pie chart and a doughnut chart.ĭownload CreatingGaugeChart.xlsx to follow along. You might think you need some fancy add-ins to create charts that look like a speedometer. Categories: Charts, Excel® Tags: Excel Gauge Chart
