Drill down into Pivot Chart

[TomBP]

Hi,

Pivot Tables have drilldown but Pivot Charts do not. I stumbled upon a macro (credits go to Craig Hatmaker) which however does exactly that but with some VBA coding.

I'm however struggling to understand where the relationship between the macro and the two charts is placed. When I for example change the name of one of the charts the drilldown still works.

I've attached a document.