Legends different when running the macro

T

Trond

Hi,

I’m creating a pivot table and a pivot diagram by vba-programing, and have a
problem with the legends of the series.

I have one series for actual values, named “ Actualâ€, and one for target
values, named “ Targetâ€. When I run my macro, the legends are just named
“Series1†and “Series2â€. I have now stepped through the macro by using F8 and
the legends are named “ Actual†and “ Targetâ€.
Why is the result different when I run my macro than when I step through it?
 

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

Similar Threads

DLookUp Format 4
cells to behave like check boxes 4
Data Validation using multiple columns 4
import from text file with VBA code 5
% completed box 1
Method ‘CurrentPage’ of object ‘Pivot ‘Failed “ 2
Adjustable Macro Code???? 4
Pivot Table Macro Run-time error 3

Top