Hi all,

I'm creating a Building Facilities Monthly Report with Raw data pasted in. I already have my Pivot Tables set up (six in total which can be filtered by building if needed) and I'd like to create charts on the next tab. One chart for each building and each of six metrics I have created. That means that I'd have to create 180 Pivot Charts in total.

I figured that I would just copy the first chart I've created and paste it below, that way it wouldn't take too long as the formatting would stay the same - I'd simply have to change the filter... Soon I've realized that this of course didn't work because of the so-called Pivot Cache that links the copied charts together and now every time I filter the copied chart, the original one gets filtered as well.

Now, I have searched for a workaround, e. g. how to disable the cache but wasn't able to find a solution.

I have also tried to create a VBA that would speed up the process; didn't work either.

Are there any other possibilities on how to create that many Pivot Charts in a more automated/faster manner?

Please feel free to ask if anything is unclear.

Thanks a million!

Cheers,
Adam