ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Can you add a KPI that works like a speedometer? (https://www.excelbanter.com/charts-charting-excel/56560-can-you-add-kpi-works-like-speedometer.html)

Sterckel

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

Andy Pope

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

Sterckel

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



All times are GMT +1. The time now is 11:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com