Speedometer Graph in Excel

by artworker in Circuits > Computers

370124 Views, 40 Favorites, 0 Comments

Speedometer Graph in Excel

value16.jpg
I have seen some speedometers in some of the professional dashboards. I thought how? How do they do it? So I did some preliminary research and came up with this speedometer. Kindly comment for any changes required. 

Insert Values

value1.jpg
Open a new workbook and enter
Value in cell B2
Max in cell C2
27 in cell B3 (exact value)
100 in cell C3 (maximum value)

Creating the Dial

value2.jpg
value3.jpg
value4.jpg
value5.jpg
value6.jpg
value7.jpg

Creating the Dial is simple. I used a doughnut graph to do that.
Doughnut in cell B12
180 in cell B13
30 in cell B14
150 in cell B15
Make sure cell B14 and B15 adds up to 180.

Select the 3 cells and create Doughnut graph from them.
Remove the legends
Change the doughnut angle and hole size to suite you. Mine was Angle=90 and hole size= 81%
Select the 180degree arc and set its fill to none.
In the same way set the other arcs to whatever color you require.

Graph for the Speedometer Pin

value8.jpg
value9.jpg
For the graph for the speedometer pin
Enter
Graph in cell B5
0 in cell B6
0 in cell B8
0 in cell C6
0 in cell C8

Now for the real thing which will use the values in cell B3 and C3
Enter formulae
=SIN(((((B3+C3)*180/C3)+90))*PI()/180)      in cell B7
=COS(((((B3+C3)*180/C3)+90))*PI()/180)    in cell C7

Speedometer Pin

value10.jpg
value11.jpg
value12.jpg
value13.jpg
value14.jpg
Select the cells B6:C8 and create a scatter with streight lines graph.
Delete the legends and all except the graph line.
Open the primary horizontal axis and set the
Minimum to -1 (fixed)
Maximum to 1 (fixed)

Open the primary horizontal axis and set the
Minimum to -1 (fixed)
Maximum to 1 (fixed)

Set the graph's background to No fill

Finally

value15.jpg
value16.jpg
Align the pin graph with the dial graph and you are done.
Change the value in cell B3 and the speedometer will show the same!

This is just a basic instructable. Change it as per your convenience as required.

Downloads