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

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

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

Good luck!
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"KateB" wrote:

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

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/ord...-excel-charts/

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"KateB" wrote in message
...
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