VBA re Graphs required plaeas

  • Thread starter Thread starter michael.beckinsale
  • Start date Start date
M

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
 
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
 
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.
 
Back
Top