#1   Report Post  
Old June 28th 07, 05:10 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 709
Default Dashboard

I've been asked by my company to develop a dashboard of metrics but I don't
know where to start. The data comes from a variety of systems and will
probably require some manipulation before it can be used. Does anyone have a
template or suggestions for getting started. Ideally I would like to update
the data and have Excel update the dashboard for me.

It's a loaded question but all help is appreciated.

Rich

  #2   Report Post  
Old June 28th 07, 05:26 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,441
Default Dashboard

Rich,

Visit Charley Kyd's site:

http://www.exceluser.com/dash/index.htm

HTH,
Bernie
MS Excel MVP


"Richard" wrote in message
...
I've been asked by my company to develop a dashboard of metrics but I don't
know where to start. The data comes from a variety of systems and will
probably require some manipulation before it can be used. Does anyone have a
template or suggestions for getting started. Ideally I would like to update
the data and have Excel update the dashboard for me.

It's a loaded question but all help is appreciated.

Rich



  #3   Report Post  
Old June 28th 07, 06:39 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2007
Posts: 13
Default Dashboard

On Jun 28, 10:10 am, Richard
wrote:
I've been asked by my company to develop a dashboard of metrics but I don't
know where to start. The data comes from a variety of systems and will
probably require some manipulation before it can be used. Does anyone have a
template or suggestions for getting started. Ideally I would like to update
the data and have Excel update the dashboard for me.

It's a loaded question but all help is appreciated.

Rich


Hi Rich. I have developed a very cool dashboard that does what you are
asking about. It uses dynamic range names for the graphing. This
allows me to paste a line in the data sheet(s) and have the dashboard
update itself. I can't send you a copy, as it has proprietary business
data, but it really not very difficult. I would suggest researching
how to build dynamic graphs, and you will be halfway home.



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
Creating a Dashboard WJM in Texas Excel Discussion (Misc queries) 10 June 16th 07 03:53 PM
KPI dashboard Julie Charts and Charting in Excel 2 January 4th 07 02:49 PM
Dashboard fkistner Excel Discussion (Misc queries) 2 March 31st 06 04:58 PM
Anyone done a gas guage in a dashboard? Stuart Charts and Charting in Excel 2 October 12th 05 10:34 PM
dashboard John O. Knoke Charts and Charting in Excel 3 May 15th 05 05:26 AM


All times are GMT +1. The time now is 08:54 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