Adjusting Major Units on Pivot Chart with Worksheet_PivotTableChangeSync

[L plates]

Hi All, I'm stuck on the correct way to call "Chart 1" (Pivot Chart) on my worksheet to allow a change of major axis value when filters are changed. I keep getting errors at the red highlighted code. I have this and have tried these and many other arrangements but am getting nowhere.

Could someone please set me straight?

Please Login or Register  to view this content.

Many thanks,

[L plates]

I got around this by setting the MajorUnit to Auto and adjusting the MinorUnit to 1 when creating the Pivot Chart.

Please Login or Register  to view this content.

Many thanks!