web analytics

HOW TO CREATE A SPEEDOMETER CHART IN MICROSOFT EXCEL 2010 – PART 1

Microsoft Excel 2010

This article is about creating a Speedometer Chart in Microsoft Excel 2010.

Microsoft Excel 2010 makes it available to create an impressive, workable Speedometer Chart, complete with a moving arrow by making a combination of several different types of charts. What is also very good about creating this Speedometer Chart is that you can control it with a scroll bar.

The Excel 2010 Chart Wizard gives us a lot of options when it comes up to chart, but in this case the Speedometer Chart is not one of them. We will show you how to create this type of chart because you can use it as a fancy way to present your data. In Excel you can also add a scrollbar in the Control Toolbox toolbar with which you can change the chart itself and sheet data at the same time.

What we need to do now is to have some data like in the picture below and create a Doughnut Chart, which is pretty much a Pie Chart, but the trick is that it can contain multiple series and the Pie hart can’t do that.

1

Now press Alt/figs/command.gif- in order to show the formula on the sheet.

Now, you can highlight the range B2:B5 and select the Chart Wizard. After you have done this, select Standard Types tab (which is set by default). After that, click on the first option from the section Chart Type. Then click on the Next button and see whether the data is charted in rows, Click on the Next button again. Now here it gives the option to make changes again, but click the Next button instead. Notice whether the chart ends up as an object in the sheet. We are placing the chart as an object as that way it is easier working it.

2

Now, you can highlight the range B2:B5 and select the Chart Wizard. After you have done this, select Standard Types tab (which is set by default). After that, click on the first option from the section Chart Type. Then click on the Next button and see whether the data is charted in rows, Click on the Next button again. Now here it gives the option to make changes again, but click the Next button instead. Notice whether the chart ends up as an object in the sheet. We are placing the chart as an object as that way it is easier working it.

3

This article continues in PART 2.

Leave a Reply