How to create a Speedometer Chart

[JAlexander2008]

For whatever it's worth, note the following:

By visiting the link below you can learn how to create your own Speedometer Chart in Excel 2007.
http://www.brainbell.com/tutorials/...A_Speedometer_Chart.htm#excelhks-CHP-5-FIG-28


With the help of John Walkenbach's Chart Tools @
http://j-walk.com/ss/excel/files/charttools.htm), and by tweaking some of the formulas in Andy Pope's tutorial I was able to create a functioning speedometer chart.

Formula tweaks:

(Following the tutorial instructions - under column E - label "Needle")

Original:

E2 = "200"
E3 = "=((180/100)*F3)-1"
E4 = "2"
E5 = "=360-(SUM(E2:E4))"

Tweaked:

E2 = "180"
E3 = "=IF(F3=0,0,((180/100)*F3)-1)"
E4 = "1"
E5 = "=360-(SUM(E2:E4))"

If anybody is interested, I will gladly upload the file.

Regards,

J.

 

[JAlexander2008]

 

[94mustang]

I am unable to find John Walkenbach's Chart Tools on the website. What add-in am I looking for? Also, it would be helpful if you uploaded the file. It would be most helpful. Thanks.

 

[lathif]

Please upload the file

 

[94mustang]

Thank you very much. This was helpful.