Pivot table and linking charts -urgent help needed

[rv02]

Hi

I have an exel spreadsheet and have used power pivot to give me sumay of sales per each division and depatmets within the division.

I have created two slicers which will break down my analysis to individual divisons and departmets within the divisions.

I have created a bar chart to inteactivelyshow me the divisions sales when I slect them from the slicer. What I want to do is when i selct a division and the graph show me the total sale from that division then I want to click on the bar grap to show me the break down of the each department's sale in another chart.


I have created a dashboard to show me the charts. However I have included a basic sample sheet to demonstrate what I need to do. I have explained on the sheet what I need to achieve

As I have large data the chart gets messy if I copy the pivot chart which whos all dept and divisions ( I have over 20 divisons and 40 departments).

I hope i am clear in what I need to achieve.

Any help is appreciate it.

[Md Aejaz]

Hi
Drag the Department to Row label area and Divisions to Column Label area then create a pivot chart by selecting the pivot table. C Select the chart type as Stacked Column.

Hope this will solve your problem.

[ashishmehra2010]

Hi,

Check sheet 2 if this helps your requirement.
Write back in case you need more help.

Regards,
AM