Pivot charts - how to filter data in charts

[eeinkee]

Hi all,
Is there any way I could filter data /information from the pivotal charts ?

So the chart gets updated once you filter cols of data in chart design?

I'm on a mac, so I'm not too sure if it works on this version of excel.

Thanks Noreen

[noboffinme]

Hi Noreen,

I'm not a Mac user but Pivot Charts have drop down boxes to filter what's being displayed.

I'm not really clear on your issue, can you advise further?

Cheers