Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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

Read More: How to Create a Gauge Chart in Excel (With Easy Steps)


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.


Related Articles

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