vba - formatting multiple pivot charts?

Hello All,

So found out how to format pivot tables using a for each...in .... loop, but need to do the same for pivot charts, and one bit of code is off.

Here is the successful code for pivot tables

Please Login or Register  to view this content.

and here is the unsuccessful code for the pivot charts

Please Login or Register  to view this content.

Code breaks on this line

Please Login or Register  to view this content.

With the phrase

Object doesn't support this property or method

sigh. so close.


EDIT: see follow-up question below

Avoid using variables names that are already being used as object names.

a chartobject does not have multiple charts.

Please Login or Register  to view this content.

You can use the macro recorder to get most of the code.

You will also need to use the SeriesCollection and Datalabels collections.