Anyone have experience with Speedometers?

Hey,

Im looking for some help regarding a speedometer chart - for those of you who've made them. I managed to get one up and running here. What Im curious about is, instead of having it go from 0 - 100, what I would like it to do is go from 0 - 7,500,000 (total budget). Problem is, if I adjust the chart data the speedometer is based on to reflect a start of 0 and a max of 7.5 million, it messes up how the chart is displaying. Do any of you know a way to fix that?

Also the needle, is showing the value of the row named, 'Pointer', and not of the total spend to date, which - the total spend to date - will come from the row titled, "value"


If not its okay, I just figured Id throw it out there, and see if anyone had experience with that.

Thank you
testsped.xlsx

Thanks Nisha! Link doesnt work though

Originally Posted by Nisha Dhawan

Hi,

Please refer this link :- http://www.exceltip.com/tips/gauge-c...oft-excel.html

Hi, here are lot of excel gauge templates: http://exceldashboardschool.com/tag/excel-gauge/