I am beginningt o embrace pivot charts for faster automated reports. Problem-
when you refresh pivots or data the chart wipes my colors and most important
the dtata point values.

So I must run through massive reports fixing many charts.

How would one approach automating a charts setting - do you build a macro to
work on active sheet or Ative Chart , for like charts can you tell it to fix
multiple sheets.

I woul dbe happy with soemhting affective that woul dneed to be activated on
the active chart - it would still save a great deal of time.

Thanks for your help and suggestions or examples would be appreciated.

Todd