How to Create Speedometer Chart in Excel (with Easy Steps)

A Speedometer Chart is a gauge where a needle points to the values at a certain point of time. Users create Speedometer Chart in Excel to track value change. There is no direct feature to create a Speedometer Chart in Excel. We need to insert a Combo Chart to create a Speedometer Chart.

Letโ€™s say we have 3 kinds of data directing 3 types of properties of a Speedometer Chart.

Dataset-How to Create Speedometer Chart in Excel

This article demonstrates the basic Speedometer Chartโ€™s components and how to create it.


Download Excel Workbook


Speedometer Chart and Its Components

Components-How to Create Speedometer Chart in Excel

A gauge chart with a needle indicating the ongoing change in values is known as the Speedometer Chart.

Performance Labels: Multiple types of performance labels, such as Poor, Average, Good, etc., are indicated on the dial.

Range Labels: For displaying the instant speed, a Speedometer Chart has range labels on it for displaying the instant speed.

Pie Chart Data: To indicate a certain point or number, a different data source needs to be assigned to create the indicator needle on the chart.


Step-by-Step Procedures to Create a Speedometer Chart in Excel

A Speedometer Chart is a Combo Chart. Users need to insert two Doughnuts and a Pie Chart to create a Speedometer Chart. Follow the below steps to insert a speedometer chart into Excel.


Step 1: Setting up Data to Create a Speedometer Chart

๐Ÿ”ผ As we mentioned earlier, a speedometer chart has 3 components, and users need an individual dataset for each of them. Enter the values for each component as shown in the below image.

Dataset


Step 2: Inserting Doughnut Charts in Excel

๐Ÿ”ผ After entering the data, go to Insert > Insert Pie or Doughnut Chart (in the Charts section) > Doughnut.

Doughnut Chart-How to Create Speedometer Chart in Excel

๐Ÿ”ผ Excel inserts a Doughnut Chart. You can choose any desired color for each portion within the doughnut chart as the Fill Color by right-clicking on the chart. Also, there is the Format Data Point option among the Context Menu options.

Context Menu

๐Ÿ”ผ The Format Data Point side window appears. In the window, type 270ยฐ as the Angle of first slice.

Format Data Pont

๐Ÿ”ผ Now, select the other half (same colored), right click on it. Choose No Fill as the Fill Color for the portion.

No Fill


Step 3: Inserting Range Labels Doughnut Chart

๐Ÿ”ผ Performance Labels indicate the different types of range, such Poor, Good, Average or Others. But to indicate an exact value, users need to add the Range Labels to the chart. Right-click on the chart > Select Data.

Range Labels-How to Create Speedometer Chart in Excel

๐Ÿ”ผ Excel fetches the Select Data Source dialog box. In the box, click on Add (under Legend Entries (Series)).

Select Data Source

๐Ÿ”ผ The Edit Series dialog box appears. Assign the respective ranges, then click OK.

Edit Series

๐Ÿ”ผ After clicking OK, Excel returns to the Select Data Source dialog box. You can see the newly added Range Labels in the dialog box. Click on OK.

Select Data Source

๐Ÿ”ผ As we trim the first slice at 270ยฐ, select the portion and fill the portion with No Fill.

No Fill


Step 4: Inserting a Pie Chart (Combo Chart)

๐Ÿ”ผ Now, adding data sources to the doughnut chart results in two doughnut charts with individual data sources. Follow Step 3 for adding another data source to insert a Pie Chart. Afterward, click OK.

Pie Chart-How to Create Speedometer Chart in Excel

๐Ÿ”ผ Right-click on the newly inserted chart, and the Context Menu appears. Choose the Change Series Chart Type.. option to insert a Pie Chart from the Change Chart Type window.

Change Data Type

๐Ÿ”ผ In the Change Chart Type window, Excel automatically selects the Combo Chart under Recommended Charts. Select a Pie Chart for the Pie Chart Data Series. Finally, click OK.

Combo Chart

๐Ÿ”ผ Go through Step 2 to cut the first slice at 270ยฐ for the Pie Chart. The Pointer reverses. Select the entire portion of the Pie Chart, right-click on it. Choose No Fill as Fill Color.

No Fill

๐Ÿ”ผ Also, select any other fill color (in this case, Green) for the needle.

Speedometer Chart-How to Create Speedometer Chart in Excel


Step 5: Adding Data Labels to the Speedometer Chart in Excel

๐Ÿ”ผ After inserting all 3 components, users need to assign data labels to individual portions. Right-click on the chart, then select any of the data sources (i.e., Series 1, Performance Labels, Range Labels, or Pie Chart Data).

Labels-How to Create Speedometer Chart in Excel

๐Ÿ”ผ Click Chart Elements > Tick Data Labels > More Options.

Chart Elements

๐Ÿ”ผ The Format Data Labels window appears. From the Label Options, tick Value from Cells, then tick on Select Range. The Data Labels dialog box appears. Insert the Performance Labels (i.e., Poor, Average, Good, etc.) as data labels.

Value from Cells

๐Ÿ”บ You see, all the Performance Labels values get inserted as data labels.

Data Labels

๐Ÿ”ผ Repeat the above process for the other 2 data sources (i.e., Range Labels and Pie Chart Data) to create a Speedometer Chart as depicted in the following image. A Text Box (Insert > Text > Text Box) with a number indicates the current speed on the Speedometer Chart.

Speedometer Chart


Conclusion

In this article, we describe the components of a Speedometer Chart and how to create one. We hope this article explains all the aspects you are looking for. Comment if you have further inquiries or have anything to add.

Have a quick visit to our amazing website and check out our recent articles on Excel. Happy Excelling.

Maruf Islam

Maruf Islam

My self, Maruf Islam, an engineer and Excel & VBA Content developer on Exceldemy. I enjoy solving problems, finding workable solutions, and most of the part I really like to take on challenges. On Exceldemy I write articles discussing various way outs of Microsoft Excel's stuck ons.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo