Multiple Pivot Charts WITH Different Criteria FROM same data source

[happydays886]

I see this was attempted on another thread within here, but the actual mechanic was not explained that well.

Basically, I'd like to have a pie chart for each Country to display the % of their respective utility; when I try to copy/make multiple charts from the same data-source, any change to the filter effects 'all' linked charts.

Help is appreciated!

[xlnitwit]

Hi,

Each chart will require its own pivot table as a data source. Simply copy and paste the original pivot table however many times you require and then create a chart from each pivot table.

[peterrc]

Hi,

Please see the attached and let us know if this is what you want.

Regards

peterrc

[happydays886]

Looks good.

Another approach I took, which did exactly what the goal was - power view. This allowed me to splice the data per chart across various divisions for graphical presentation.