Dynamic Pivot Charts: show data from last 6 periods only

[robertgroen92]

Hi Folks,

I'm working on a dashboard that shows some market developments.
I'm using several Pivot Charts (in the analysis sheets) and I'd like these charts to automatically show data for only the last 6 periods (years/quarters). I've been trying to figure out how to get this to work, but no breakthrough so far.

I think a macro is needed to get this to work, but I'm a real beginner with this. I would greatly appreciate any help! I've attached the file in case that helps.

Best,
Robert

Analysis Test.xlsm

[robertgroen92]

Even some pointers in the right direction would be extremely appreciated. I'm completely stuck on this...

The problem is that data will be added in the source, which will automatically update in the pivot chart. Over time the chart will become too full, and I'd like to only show the last X periods in the chart. Thanks in advance to anyone who helps.