Last week I was browsing through various graphics I used in my presentations and the speedometer struck me. Following is a sample speedometer graph created from excel:
As always, there are several blogs available for creating this manually. Also Excel 2013 has some apps which helps you create this easily. For reference:
http://office.microsoft.com/en-us/store/gauge-WA103524919.aspx
But for poor souls like me who are still stuck with Excel 2007 or 2010, creating this graph from scratch is a big pain. Also you would need good amount of excel skills to make the required changes.
I spent the last one hour trying to create a customizable template which can be used with various data ranges rather than being stuck with 0-100 and I would say I am pretty happy with the results. :)
I could not test it for multiple scenarios and all comments are welcome. You could format the graphs bit more to suit your aesthetic senses. I just love the color "black".
As always, the template can be downloaded from the following location:
Speedometer
No comments:
Post a Comment