Hi all,

New to the forum, excited to be here. I've never had a problem in Excel that somebody else hasn't already had. That said, apologies if this is a familiar problem...

I've got a large data set. There are a lot of charts that need to be created from this data set, and they need to be live as filters are applied to the data set.

I've set up a few Pivot Tables/Pivot Charts to create the charts. However, I don't want to have to select the fields in each pivot table to chart. I want the user to be able to filter data in the master set and have those filters flow through to the Pivot Charts. Otherwise there is going to be way too much data in the charts.

Is there an easy way to force these filters to flow through? Thanks for any help, I'm much better with formulas than I am with Pivot Tables!