Speedo Dial Chart

mikeymay

Well-known Member
Joined
Jan 17, 2006
Messages
1,480
I want to create a Speedo style chart that look like the attached image

e02yah.png


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


Thanks
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

mikeymay

Well-known Member
Joined
Jan 17, 2006
Messages
1,480
Thanks Michael but I am looking for something very specific as per the image.
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,763
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
Good luck....try Triumph...:biggrin:
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

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,118
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS

ADVERTISEMENT

Doubtful - Jon doesn't like speedo charts.
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,763
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
Hey RoryA
Yep, i'm hearing ya!!
and they were really great in 97...:unsure:
 

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,943
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS

ADVERTISEMENT

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

Well-known Member
Joined
Jan 17, 2006
Messages
1,480
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

MrExcel MVP
Joined
May 14, 2003
Messages
4,943
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
You don't think that it's worthwhile to educate a client?
 

mikeymay

Well-known Member
Joined
Jan 17, 2006
Messages
1,480
The client has since shared with me why they want this and it puts more context around it.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,970
Messages
5,599,108
Members
414,288
Latest member
horizon2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top