Page 1 of 1

Controlling Order of Items in Legend Box

Posted: Thu Dec 10, 2009 8:39 am
by 9092401
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.

Re: Controlling Order of Items in Legend Box

Posted: Sun Dec 13, 2009 11:57 am
by 9092401
Hi
You might have missed this one .
Can you please help
Thanks.

Re: Controlling Order of Items in Legend Box

Posted: Mon Dec 14, 2009 4:38 pm
by 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.

Re: Controlling Order of Items in Legend Box

Posted: Mon Dec 21, 2009 4:30 pm
by 9092401
Hi Yeray
Excellent idea , and it works too :D
Thanks very much .