Speedo Dial Chart

[mikeymay]

I want to create a Speedo style chart that look like the attached image

Specifically I need the varying sizes if lines to represent 1, 5 and 10 mph as per the image.


Thanks

 

[Michael M]

A quick google found this

Download Speedometer/ Gauge Chart template in MS Excel | Spreadsheet Paul

 

[mikeymay]

Thanks Michael but I am looking for something very specific as per the image.

 

[Michael M]

Good luck....try Triumph...
I'm guessing if you want to be that specific, you'll need to design your own.
But try visiting Jon Peltiers website.
If it can be done with charts...it'll be there !!

Jon's Excel Charts and Tutorials - Index

 

[RoryA]

Doubtful - Jon doesn't like speedo charts.

 

[Michael M]

Hey RoryA
Yep, i'm hearing ya!!
and they were really great in 97...

 

[Jon Peltier]

This can be done, and there are myriad examples.

But why? The dashboard you're making isn't for your car or private jet, it's for your business. Dials don't mean squat, other than being useless eye candy. They take up a lot of room to show a single value, and they don't show trends, just a solitary value. They also make it very difficult to compare value with each other.

To show the value with its trend, use a line chart showing the last several periods leading up to the current value.

To show a single value in a small amount of space, in such a way that makes comparison between several such values side-by-side, use bullet charts. I've just written a tutorial showing a quick and easy way to do Bullet Charts in Excel.

 

[mikeymay]

Thanks Jon.

It's something a client has requested so I am happy to waste my time building something useless as long as their paying for it!

 

[Jon Peltier]

You don't think that it's worthwhile to educate a client?

 

[mikeymay]

The client has since shared with me why they want this and it puts more context around it.