Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Speedo Dial Chart

  1. #1
    Board Regular
    Join Date
    Jan 2006
    Location
    Leeds, UK
    Posts
    1,256
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Speedo Dial Chart

    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

  2. #2
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    Western NSW
    Posts
    15,520
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default re: Speedo Dial Chart

    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  3. #3
    Board Regular
    Join Date
    Jan 2006
    Location
    Leeds, UK
    Posts
    1,256
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default re: Speedo Dial Chart

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

  4. #4
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    Western NSW
    Posts
    15,520
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Speedo Dial Chart

    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
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  5. #5
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    30,113
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Speedo Dial Chart

    Doubtful - Jon doesn't like speedo charts.

  6. #6
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    Western NSW
    Posts
    15,520
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Speedo Dial Chart

    Hey RoryA
    Yep, i'm hearing ya!!
    and they were really great in 97...
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  7. #7
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,386
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Speedo Dial Chart

    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.
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

  8. #8
    Board Regular
    Join Date
    Jan 2006
    Location
    Leeds, UK
    Posts
    1,256
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Speedo Dial Chart

    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!

  9. #9
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,386
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Speedo Dial Chart

    You don't think that it's worthwhile to educate a client?
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

  10. #10
    Board Regular
    Join Date
    Jan 2006
    Location
    Leeds, UK
    Posts
    1,256
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Speedo Dial Chart

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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com