Very Dynamic & linked dashboard

[Marco_1974]

Dear readers, looking for information about dynamic dashboards, graphs and pivots, I stumbled upon this great site!

Hope you want to join my travel in getting laid down the fundamentals for my dashboard..

Please find enclosed excel file with data. Finally I want to link all together, showing graphs upon the choose of the first graph. Hopefully you want to help me across...
For first instance not with the solution but the way to go, so I can learn, instead of "copy-paste"...

Ok, here we go, the first thing I want to achieve is to make a choise complaints per department. I also want to let them see separately annd combined.
Should I go here for the dynamic chart or with the dynamic pivot?

Perhaps for further information, based upon the decision here what to show in the graph, the next graphs in the dashboard are made upon that...

Looking forward to your responces and thanks for that in advance.

Rgrds, Marco

 

[NARAYANK991]

Hi Marco ,

Today being Sunday , you may or may not get many responses today ; please wait for a day or two.

Narayan

 

[dan_l]

Why not do both? The pivot table bakes in really simple ways to sort and filter the data, getpivotdata() is a great way to extract data from a pivot and put it into whatever chart you want.

 

[Marco_1974]

Hi Marco ,

Today being Sunday , you may or may not get many responses today ; please wait for a day or two.

Narayan

Ok, thanks Narayan..looking forward to te responces.

rgrds, Marco

 

[Marco_1974]

Why not do both? The pivot table bakes in really simple ways to sort and filter the data, getpivotdata() is a great way to extract data from a pivot and put it into whatever chart you want.

Dan, understand your suggestion, but what about my next graph then...?
For understanding:
2 graph's beside each other (my dashboard consists of more, but I want to understand step by step..)
IN the first graph the amount of complaints per department are displayed. With choosing a department, in the second graph, the financial figures are stated. In this graph I want also choose: scrap/rework/Na....

 

[dan_l]

Have a look at this. I threw this together over a cup of coffee just for demonstration, so nothing about it is good and/or well thought out.

FWIW, you could probably do this with one pivot table if you really wanted to.

 

[Marco_1974]

I've played around with your file, Dave.
Looks good for me.
Now preparing the next step. Will come back when needed.

Rgrds, marco

btw sorry for my late responce....had to deal with the flue...

 

[Marco_1974]

Is it also possible to have an active filter on the column labels..?

 

[dan_l]

Yeah: It's just a matter of how you want the filter to work that determines whether you set the user selection to filter the pivot tables themselves or if you want to do it in the chart layout area.

Post an example of what you're trying to do?

 

[Marco_1974]

Yeah: It's just a matter of how you want the filter to work that determines whether you set the user selection to filter the pivot tables themselves or if you want to do it in the chart layout area.

Post an example of what you're trying to do?

Want to filter like included jpg.
I'm able to filter in the report header, bu want now filter in the row labels. Using dropdown in the graph will give another graph, of the choosen row label, without going to the pivot...

 

[dan_l]

Yeah. The page filters are easy.
http://chandoo.org/wp/2011/08/10/mlb-pitching-stats-dashboard/

Try the above - it uses the same technique.

The row filters might be a little bit trickier but it can be done. Again, the big question is do you want to filter those just in the chart or do you want to do it on the pivot table with vba.