Legends different when running the macro

[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?

 

[paul.robinson]

Hi
Some code would help a lot.
regards
Paul