+ Reply to Thread
Results 1 to 4 of 4
  1. #1
    Sterckel
    Guest

    Can you add a KPI that works like a speedometer?

    Dear all, I want to visualize our performance in a speedometer like KPI.
    Which looks like below with a needle to point the status

    100%
    95% .. ..105%
    .. ..
    75%.. .. 125%

    In awaitence of your reply.
    Thanks in advance

    Mark Sterckel
    Customer Service manager


    ----------------
    This post is a suggestion for Microsoft, and Microsoft responds to the
    suggestions with the most votes. To vote for this suggestion, click the "I
    Agree" button in the message pane. If you do not see the button, follow this
    link to open the suggestion in the Microsoft Web-based Newsreader and then
    click "I Agree" in the message pane.

    http://www.microsoft.com/office/comm...excel.charting

  2. #2
    Andy Pope
    Guest

    Re: Can you add a KPI that works like a speedometer?

    Hi,

    Here are a couple of examples,
    http://peltiertech.com/Excel/Charts/SpeedometerXP.html
    http://www.andypope.info/charts/gauge.htm

    Cheers
    Andy

    Sterckel wrote:
    > Dear all, I want to visualize our performance in a speedometer like KPI.
    > Which looks like below with a needle to point the status
    >
    > 100%
    > 95% .. ..105%
    > .. ..
    > 75%.. .. 125%
    >
    > In awaitence of your reply.
    > Thanks in advance
    >
    > Mark Sterckel
    > Customer Service manager
    >
    >
    > ----------------
    > This post is a suggestion for Microsoft, and Microsoft responds to the
    > suggestions with the most votes. To vote for this suggestion, click the "I
    > Agree" button in the message pane. If you do not see the button, follow this
    > link to open the suggestion in the Microsoft Web-based Newsreader and then
    > click "I Agree" in the message pane.
    >
    > http://www.microsoft.com/office/comm...excel.charting


    --

    Andy Pope, Microsoft MVP - Excel
    http://www.andypope.info

  3. #3
    Sterckel
    Guest

    Re: Can you add a KPI that works like a speedometer?

    Thanks Andy!
    This was just what I was looking for.

    Mark

    "Andy Pope" wrote:

    > Hi,
    >
    > Here are a couple of examples,
    > http://peltiertech.com/Excel/Charts/SpeedometerXP.html
    > http://www.andypope.info/charts/gauge.htm
    >
    > Cheers
    > Andy
    >
    > Sterckel wrote:
    > > Dear all, I want to visualize our performance in a speedometer like KPI.
    > > Which looks like below with a needle to point the status
    > >
    > > 100%
    > > 95% .. ..105%
    > > .. ..
    > > 75%.. .. 125%
    > >
    > > In awaitence of your reply.
    > > Thanks in advance
    > >
    > > Mark Sterckel
    > > Customer Service manager
    > >
    > >
    > > ----------------
    > > This post is a suggestion for Microsoft, and Microsoft responds to the
    > > suggestions with the most votes. To vote for this suggestion, click the "I
    > > Agree" button in the message pane. If you do not see the button, follow this
    > > link to open the suggestion in the Microsoft Web-based Newsreader and then
    > > click "I Agree" in the message pane.
    > >
    > > http://www.microsoft.com/office/comm...excel.charting

    >
    > --
    >
    > Andy Pope, Microsoft MVP - Excel
    > http://www.andypope.info
    >


  4. #4
    Forum Moderator teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    2003 & 2010
    Posts
    10,042

    Re: Can you add a KPI that works like a speedometer?

    Please don't. This question is over 5 years old. Start your own question or write an article in Tips and Tutorials.
    teylyn
    Microsoft MVP - Excel
    At Excelforum, you can say "Thank you!" by clicking the icon below the post.

    Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.2.0