Is there anyone who creates dashboards for a living?

[katy1985]

I want a dashboard setting up, but i just dont have the time to do it! Its fairly basic and i could tweak the formatting after but its lots of rolling charts.

Anyone intersted???

[AndyLitch]

Upload the file and let's have a look...I'm only in Derby

[nemo74]

are you paying or offering this for fun? lol

[katy1985]

The data could be considered sensitive. Ill create a file with false data and send upload it soon. Thanks

[AndyLitch]

NP .. No rush !

[katy1985]

Here it is!

[AndyLitch]

......... Apologies for the delay I've managed to crash Excel twice now, halfway through setting up the dashboard... Concentration is fading...

[katy1985]

[AndyLitch]

Example (9).xlsx

Just a quick example for you to ok... I was thinking a couple of selectable charts like this one accompanied by some statistical data of the displayed charts and a snapshot facility.
I'm not concentrating too well right now though, I think it's beer time.

[katy1985]

Yep its starting to look good, hope you enjoyed your beer

[AndyLitch]

Always do Katy ......... Now it's a new day with a 'clear' head.

Question ..... Can i reformat your main data sheet slightly to make data extraction simpler ?

[katy1985]

Yeah, do whatever you want. Just bear in mind that data will be added monthly, and ideally the charts will be rolling year charts i.e. from March 2012 to March 2012
I managed a rolling chart, in the attached, but it do it repeatedly, in a dashboard it way beyond my skill level

[AndyLitch]

Not a problem...I'll rejig it slightly and we can go from there..

[AndyLitch]

DashBoard.xlsm

OK... I've changed the data entry sheet so that it's laid out primarily for ease of Excel.. Can you just check it's ok before i go on to the dashboard development proper.

[AndyLitch]

DashBoard.xlsm

Stage 2

[nemo74]

Andy,
The buttons to select the month to be displayed on the charts is awesome, awesome, awesome! Once you are done I'll be learning how you did that and put it in my bag of tricks. Great job so far!

[AndyLitch]

Thanks nemo .... appreciate the compliment and always glad to help

[AndyLitch]

1.jpg

Image shows dashboard report