Hi,

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

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?