View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.robinson@it-tallaght.ie is offline
external usenet poster
 
Posts: 789
Default Legends different when running the macro

Hi
Some code would help a lot.
regards
Paul

On Feb 6, 7:44*am, Trond wrote:
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?