Scatter Graph - bring line to front

[KateB]

Is is possible to change the order of the lines shown on a scatter
graph? It seems that they are drawn from the first series to the last
- is there any way to move them around in this list / bring the line
to the front? I have some very long series and some code would be
most helpful.

Thanks!
Kate

 

[ryguy7272]

These two resources are pretty comprehensive:
http://peltiertech.com/Excel/Charts/ChartIndex.html

http://www.andypope.info/charts.htm

Good luck!
Ryan---

 

[Andy Pope]

Hi,

If the series are all of the same chart type and on the same axis then you
can alter the series order.
Double click as series and goto the Series order tab.

For more detail on order see Jon's blog
http://peltiertech.com/WordPress/order-of-legend-entries-in-excel-charts/

Cheers
Andy