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

Get FREE Advanced Excel Exercises with Solutions!

A Meter Chart or Speedometer Chart is crucial for vehicles to understand their speed or velocity. Using Microsoft Excel, we can easily create a meter chart. Creating a meter chart in Excel is an easy task. This is also a time-saving task. Today, in this article, we’ll learn four quick and suitable steps to create a meter chart in Excel effectively with appropriate illustrations.


Watch Video – Create Meter Chart in Excel


Introduction to Meter Chart

An Excel Meter Chart or SPEEDOMETER Chart is similar to a speedometer with a needle that displays a number on the gauge and moves in response to changes in the data. A single data point can be tracked against a target using a single-point chart.

create meter chart in excel


How to Create Meter Chart in Excel: 4 Quick Steps

Let’s say, we have a dataset that contains information about several speeds of a vehicle. First of all, we will make a dataset with parameters. After that, we will make a meter chart in Excel to understand the speed of a vehicle with changes in time. Here’s an overview of the dataset for our today’s task.

create meter chart in excel


Step 1: Create Dataset with Proper Parameters

In this portion, we will create a dataset to make a meter chart in Excel. We will make a dataset that contains information about several speeds of a vehicle. We calculate the end value of the pointer using the simple mathematical formula. The formula is,

=200-F5-F6

Where 200 is the total reading of speed, F5 is the speed value, and F6 is the pointer value.

So, our dataset becomes.

create meter chart in excel


Step 2: Make Doughnut Pie Chart

After creating the dataset with proper parameters, we will create a meter chart using the dataset. Let’s follow the instructions below to learn!

  • First of all, select cells range from B5 to C9. Hence, from your Insert ribbon, go to,

Insert → Charts → Pie Chart → Doughnut

  • As a result, you will be able to create a Doughnut Pie chart using the dataset which has been given in the below screenshot.

create meter chart in excel

Read More: How to Create a Gauge Chart in Excel


Step 3: Give Format to Meter Chart

Now, we will give the formatting of the meter chart. We can easily do that in Excel. Let’s follow the instructions below to learn!

  • First, place your cursor on the chart and press right-click on Mouse. As a result, a window will appear in front of you. From that window, select the Format Data Series option.

  • Hence, a Format Data Series drop-down list pops up.
  • After that, type 2700 in the Angle of first slice typing box under the drop-down list named Series Options.

create meter chart in excel

  • Further, select the bigger portion of the Doughnut chart, and check the No fill option under the Fill drop-down list.

  • As a result, our chart becomes like the below screenshot.

create meter chart in excel

  • Now, we will create a pointer to the meter chart. To do that, place your cursor on the chart and press right-click on Mouse. As a result, a window will appear in front of you. From that window, select the Select Data option.

  • Hence, a dialog box named Select Data Source will appear in front of you. From the Select Data Source dialog box, select the Add option.

create meter chart in excel

  • As a result, an Edit Series dialog box pops up. From the Edit Series dialog box, type =’Meter Chart’!$E$4:$F$4 in the Series name typing box.
  • Again, type =’Meter Chart’!$E$4:$F$4 in the Series values typing box.
  • At last, press OK.

  • After that, you will back to the Select Data Source dialog box and press the OK option.

create meter chart in excel

  • Hence, you will create a new chart. Now, we will change the type of the chart. To do that, place your cursor on the chart and press right-click on Mouse. As a result, a window will appear in front of you. From that window, select the Change Series Chart Type option.

  • Further, a Change Chart Type dialog box pops up. From the Change Chart Type dialog box, select Pie chart in the pointer At last, press OK.

create meter chart in excel

  • Now, select the bigger two portions of the Pie chart, and check the No fill option under the Fill drop-down list.

  • After that, type 2700 in the Angle of first slice typing box under the drop-down list named Series Options.

create meter chart in excel

  • Finally, after completing the above process, you will create a meter char which has been given in the below screenshot.


Step 4: Check Meter Chart

In this section, we will check whether our meter chart works or not. Let’s follow the instructions below to learn!

  • We will change the pointer value from 3 to 5, and we will notice that the thickness of the pointer changes automatically, which has been given in the below screenshot.
  • You can also change the speed value to check the meter chart. If you change the value of the speed, the pointer position will change automatically.

create meter chart in excel


Things to Remember

➜ While a value can not found in the referenced cell, the #N/A! error happens in Excel.

➜ #DIV/0! error happens when a value is divided by zero(0) or the cell reference is blank.


Download Practice Workbook


Conclusion

I hope all of the suitable methods mentioned above to create a meter chart will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.


Related Articles


<< Go Back to Meter Chart in Excel | Excel Charts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Abdur Rahim Rasel
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo