#1   Report Post  
Old January 3rd 07, 10:57 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 150
Default KPI dashboard

I need to create a market intelligence report that we can incorporate a
dashboard showing how leadtimes, pricing and supply has changed. We
envisaged a semi circle dashboard coloured red, orange and green that we can
move the dial towards indicating where we stand on each element. Is there
something easy within excel that I can use

  #2   Report Post  
Old January 3rd 07, 11:10 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default KPI dashboard

Hi,

See Jon's example,
http://peltiertech.com/Excel/Charts/SpeedometerXP.html

Cheers
Andy

Julie wrote:
I need to create a market intelligence report that we can incorporate a
dashboard showing how leadtimes, pricing and supply has changed. We
envisaged a semi circle dashboard coloured red, orange and green that we can
move the dial towards indicating where we stand on each element. Is there
something easy within excel that I can use

  #3   Report Post  
Old January 4th 07, 02:49 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default KPI dashboard

It may be more useful to use a line chart, which not only shows the latest
value, but the trend leading up to this value. You can use stacked area
series in the same chart to show the colored regions. Such a line chart
takes up less room than one of these speedometer gauges, and shows a more
complete picture of the data.

People have been conditioned to think a dashboard chart should have lots of
dial gauges, but really it should be a place where you can look at a lot of
relevant information at once.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Andy Pope" wrote in message
...
Hi,

See Jon's example,
http://peltiertech.com/Excel/Charts/SpeedometerXP.html

Cheers
Andy

Julie wrote:
I need to create a market intelligence report that we can incorporate a
dashboard showing how leadtimes, pricing and supply has changed. We
envisaged a semi circle dashboard coloured red, orange and green that we
can move the dial towards indicating where we stand on each element. Is
there something easy within excel that I can use





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 BI Dashboard Michael Excel Discussion (Misc queries) 0 June 23rd 06 09:37 PM
Dashboard fkistner Excel Discussion (Misc queries) 2 March 31st 06 04:58 PM
How do I create a dashboard in Excel? ericanardi13118 Excel Discussion (Misc queries) 2 February 9th 06 09:19 PM
dashboard measurement syatems gerrythefishwick Charts and Charting in Excel 0 January 27th 06 12:51 AM
dashboard I can use for Excel or PowerPoint Paul Charts and Charting in Excel 4 February 24th 05 11:38 PM


All times are GMT +1. The time now is 10:46 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017