Creating a Dashboard

[JamieLee2k]

I am looking to create a Dashboard for my work that I have done over the course of the year and my aim is to pull data from each worksheet (i.e week 1, week 2, week 3, etc.....) and put all the stats that I require into the dashboard which I have no idea how it will even look like.

I do know that the data I need (to start with) is:

• Total Good Units Done
• Total Failed Units Done
• Total Percentage of Work Done (Up to Date, but will include new work to be added)

There maybe more but for now I just need to figure out how to pull data as I have 52 sheets (eventually) I am wanting to pull data from.

I know this could be a hard task but I am willing to put them online if that makes it easier, that way if I have the Dashboard with me I can pull data anywhere I want. (Providing I have internet access)

If anyone can help me that would be great.

Thanks in Advance
JamieLee2k

 

[hiker95]

JamieLee2k,


See if one of these helps you get started in the right direction:

How to create Excel Dashboards
http://www.contextures.com/excel-dashboards.html
http://chandoo.org/wp/excel-dashboards/
http://chandoo.org/wp/management-dashboards-excel/
http://www.exceldashboardwidgets.com/

Excel Dashboard / Scorecard Ebook
http://www.qimacros.com/excel-dashboard-scorecard.html

Mike Alexander from Data Pig Technologies
Excel 2007 Dashboards & Reports For Dummies

 

[JamieLee2k]

Thanks for the reply, It's not what I am looking for but still good info.

What I am after is a way to take data from one workbook to a Dashboard in which I want to create.

I have all the files uploaded to a server if that helps as that will be better for me in the long run.

 

[JamieLee2k]

Do anyone else know of any way to do this?