View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default multiple data series in an x-y scatter chart - Excel 2003

Hi,

Changing the order of the series works fine here.
Right click on a data point and go to Format Data Series
On the Series Order Tab put the series you want to bring
to the front on the top of the stack with the move up and move
down buttons.

I use 2000 so there may be a slight difference in 2003 but I think
the basics should be the same.

HTH
Martin


"Excel 2003" <Excel wrote in message
...
Hi;
I have three data series plotted on an x-y chart. Two of the series have
lines connecting the data points, and one does not.

I want to make it so that the two lined series appear on top of the series
without lines.

In every other software program in the universe, there is a "send to back"
and a "bring to front" option under the ordering of objects which is the
command I need...and Excel has this as well but only for objects in the
chart, not for the data series.

I've looked everywhere, and there MUST be a way to accomplish this, but I
can't find it.

PS - I've tried modifying the order of the series, but that doesn't change
which one appears on top of the others, and for some reason Excel has
decided
to put the series that I don't want on top - on top.