VBA re Graphs required plaeas

  • Thread starter michael.beckinsale
  • 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
 
M

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top