Right click the pie chart and choose Change Series Chart Type.Then, click the radio button for Secondary Axis. Change the Angle of the first slice to 270.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. A great way to create a self-expanding chart in Excel.įinally, give this charting technique a go, it a good one to have in your Excel magic box of tricks.By Melissa Esquibel Categories: Charts, Excel® Tags: Excel Gauge Chart So, as you can see in the screenshot above Northern has been added in automatically after I typed it then tabbed along to the Widget Sales ready for the figure to be entered. Excel recognises the data as a table and that any data that is added to it, is automatically updated in the chart. Note, if you are using Excel 2003 in Step 3 above choose Data- List-Create List.īelieve it or not, that’s all there is to it!!. Choose Insert- Tables Tables to convert the range to a table.Select any cell in the range that contains data that is used by the chart.Create your chart as usual ( you can use the sample data below).To create your self expanding chart in Excel 2007 and Excel 2003 do the following Let’s look at Excel 2007 and Excel 2003 first. So, in Excel 2007 we can use a new table feature if you need the workbook to be backward compatible with previous Excel 2003 versions you need to do a few more clicks to get the same result. We can allow a chart to automatically accommodate new data as it is added. But, by a few tweaks and Excel magic, we can set up a chart differently. Normally a chart is set up to only display what is currently on the datasheet. So, it is really easy to create a self-expanding chart in Excel. I will show you how to create a self-expanding chart. Hello Excellers, welcome back to another Excel tip today.