Right click the pie or, in the Layout tab in Excel 2010, in the first field in the ribbon, choose Series “Needle”, then Format Selection, below it.Right click the outer doughnut and choose Change Series Chart Type.The next steps vary depending upon whether you are using Excel 2010 or earlier and Excel 2013 or later. Click the Add button and Name the new series “Needle.” Navigate to the Series values field and select the Position, Needle and End data. Right click the gauge chart you just created and choose Select Data. 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. Modify the chart to look like the half-circle dial.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. Create the speedometer with a doughnut chart.A formula which subtracts the sum of these values from 360.Position of the needle, your actual data value.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. By Melissa Esquibel Categories: Charts, Excel® Tags: Excel Gauge Chart
0 kommentar(er)
