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

A Meter Chart or SPEEDOMETER Chart is very 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 a time-saving task also. Today, in this article, we’ll learn four quick and suitable steps to create meter chart in Excel effectively with appropriate illustrations.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


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


4 Quick Steps to Create Meter Chart in Excel

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


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 2700in 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 2700in 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.


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.

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo