Md. Abdur Rahim Rasel
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.
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.
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-F6Where 200 is the total reading of speed, F5 is the speed value, and F6 is the pointer value.
So, our dataset becomes.
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.
Read More: How to Create a Gauge Chart in Excel (With Easy Steps)
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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
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.
