Controlling Order of Items in Legend Box

[qcrnd]

Hi
I have an chart with 3 area series and I have to add them each differently according the the area which is higher so that no area will be hidden
However I do not want to order of the items in the legend box to change as well. I always want the order of the items to be the same. Currently I see that their order is dependant on the order I add the series to the chart.
How can I control this.
Thanks.

[qcrnd]

Hi
You might have missed this one .
Can you please help
Thanks.

[Yeray]

Hi qcrnd,

You cannot control the legend items order directly without altering the Z order too. What you could do is to add three dummy series in the desired order you wish to be shown in the legend and hide the other series from the legend. See the series' ShowInLegend property.

[qcrnd]

Hi Yeray
Excellent idea , and it works too
Thanks very much .