VBA re Graphs required plaeas

[michael.beckinsale]

Hi All

I have a number of graphs on several sheets and would like to do the
following using VBA code

Refresh ALL pivots tables in the workbook
Loop through all the graphs in the workbook and :
Add 'Value' data labels for each of the series
Consistently colour each of the series

The series have consist names however they do not always appear in
each graph

Any pointers gratefully apprciated

Regards

Michael

 

[michael.beckinsale]

Hi All,

Sorry if anybody has spent any time on this - l have now got rid of
that 'Monday morning feeling' and got my head round this. Problem
solved.

Regards

Michael

 

[Don Guillett Excel MVP]

Hi All,

Sorry if anybody has spent any time on this - l have now got rid of
that 'Monday morning feeling' and got my head round this. Problem
solved.

Regards

Michael

The ARCHIVES would like to see your solution.