Automatic generation of multiple pivot tables, using different filters?

[Greg Kinney]

Hello, my apologies if this was asked elsewhere, but I did make a legitimate effort to find it first.

I have a pivot table and resulting pivot line chart that shows costs vs budget by month for an entire division. I would like to see this same exact chart for each project within the division. I can do this manually using a report filter. However, there are 60 or so projects, and I want to do this monthly, so automation is key.

Is there some function that would automatically generate each possible chart according to a report filter in a new tab? If not, is there a reasonable way to do this using macros? Or VBA?

Any help is greatly appreciated!

[Shareez Saleem]

Insert a "Slicer" (Department).