Today I will tell you how create a Speedometer chart in excel. we can use speedometer chart to show a KPI metric. An Image has been given below for a speedometer.
Step by step tutorial for a speedometer:
6.
Go to Insert > Chart >
Watch this video to learn step by step tutorial of Speedometer-
Step by step tutorial for a speedometer:
1.
Put “A1” to “A10” 10%
2.
Put 100% on “A11”
3.
Actual Value on “D2”
4.
Indicator width on D3 as 1 %
5.
Rest value at D4. Put formula “=2-Sum(D2:D3)”
7.
Insert a Doughnut chart
8.
Right click on doughnut and click on Format Data
Series
9.
Under Series Option change "Angle of first
Slice" from 0 to 270 degree.
10.
fill the half part of doughnut as no fill.
11.
Fill color in the rest slices as give below image.
12.
Right click on the graph and click on “Select
Data”
13.
Under “Legend Entries (Series)” click on Add.
14.
Select Series Name “C2”
15.
Series value range “D2:D4” and click OK
16.
Right click on doughnut and click on “Change
Series Chart Type”.
17.
Select Actual value “Pie” as given below image.
18.
No fill in Pie chart except Indicator width part
(“1%”)
19.
Fill black color in Indicator width part (“1%”)
and remove outline in pie chart.
20.
Right click on Pie chart and click on “Format
Data Series”
21.
In “format Data Series” under Plot Series on
click on “Secondary Axis”
22.
In “Angle of first Slice“ put value 270 degree.
23.
Now go to Insert > Shapes > Ovel
24.
Drag Ovel shape on the Image.
25.
Select the Ovel shape and go to Format >
Shape Effects > Preset > Preset 3
26.
Inset a text box and connect with Actual value “D2”
Speedometer chart is ready. If
value of D2 will be changed, indicator of speedometer chart will be changed
accordingly.
Please download the excel file
from below given link
Watch this video to learn step by step tutorial of Speedometer-
can you help me with my case, because I've do kind of formulas but still find the result (error).
ReplyDeleteI made screenshot for my case on this URL image
>>> http://suryakarimun.com/excel/HELP.jpg
thank you for helping..
http://suryakarimun.com/excel/HELP.jpg
Deletehi was just seeing if you minded a comment. i like your website and the thme you picked is super. I will be back. GPS Speedometer
ReplyDeleteI went to this website, and I believe that you have a plenty of excellent information, I have saved your site to my bookmarks. Speed Tracker App
ReplyDeleteYou have beaten yourself this time, and I appreciate you and hopping for some more informative posts in future. Thank you for sharing great information to us. Odometer
ReplyDelete