Change order of series in chart

[Heinz-Guenter Lamy]

Hello there,

I have built up a rather complicated customized chart
with about 10 series.
Now I added an 11th one, whose datapoints
overlay some of the earlier series.

Is there a way to determine the order of dataseries
once a chart has been created without starting from
scratch ?

Thank you in advance.

Kind regards,

H.G. Lamy

 

[Tushar Mehta]

Double click any series, then in the resulting 'Format Data Series'
dialog box, select the 'Series Order' tab.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[hglamy]

Thank you, Tushar !

I knew I had found that once, but now was unable to get there again !

Regards,

H.G. Lamy