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. You can format the rest of the chart exactly like you did for the Bar chart.By Melissa Esquibel Categories: Charts, Excel® Tags: Excel Gauge Chart Your chart should look something like this one:Ĭhange the rest of the slices in exactly the same way. Set the Point Explosion slider to about 30% To move the slice that you've just coloured, click back on Series Options from the options on the left: We've gone for a dark orange colour, but select any colour you like. Now click the colour picker, and choose a new colour for the segment: There are quite a lot of options to experiment with. Select Solid fill, and select a colour from the dropdown list:įill from the options on the left. You'll see a panel appear on the right of your screen in Excel 20.Ĭlick the paint bucket icon at the top, then click to expand the Fill option. You should see the following dialogue box appears in Excel 2007: Now right click your segment and, from the menu that appears, select Format Data Point: You should see round circles surrounding just that segment. In the image above, only the 10.99 segment is selected.

It's a little bit tricky, but if you do it right your pie chart should look like this: Now left click on one of the segments to select just that individual slice. It is selected when you can see those round handles. Left click on the pie chart itself to select it: Change the Colour of a Pie Chart Segement You can change the colour of each slice of your pie chart, and even move a slice. From the previous lesson, your Pie Chart segements look like this:

Create pie chart in excel 2010