Add source to pivot chart

[jaryszek]

Hi Guys,

i am loosing pivot chart source after changing source data for pivot table (in my case worksheet copying).
But it is easy (i hope) way to fix it - how to add soure data to add it into not linked pivot chart via VBA?

Screenshot_19.png

In attachment please find example workbook with Source, Pivot, Linked Chart and not linked chart - please help with linking the last one.

Best,
Jacek

[jaryszek]

Anyone knows?

Jacek

[jaryszek]

Please help,

Jacek

[Andy Pope]

This will set the charts data source to be a pivot table.

Please Login or Register  to view this content.

[jaryszek]

this is awesome !

Thank you so so so much!

Jacek