Pivot Charts - Formatting

[Mike]

I need to update about 120 charts per week using pivot
charts. Since the data changes weekly, I lose any
formatting to the lines on the graph. Can I update all
the graphs using a macro? If so, where do I start the
macro - on the pivot data tab or on the pivot chart itself?

 

[Debra Dalgleish]

At the simplest level, you could record a macro as you refresh and
reformat the charts manually. Then, play the macro each week to
automatically perform the task.

Depending on how the PivotCharts change, and where they're located, you
may be able to write some code to loop through them and make the
changes. However, without any details on the charts, it would be very
difficult to suggest any appropriate code.