For a chart with several points and lines expressed in different colors,
some often overlapping another, what determines what color is "on top" of
the other.

I have a situation where a data point market is obscured by the error bar of
something else.

Will re-ordering the data series change this? How?

My thanks in advance for any suggestions.

Cheers! Brad

Hi,

Series order will affect how error bars overlay each other but for series on
the same axis the markers appear over the error bars.
If the series is on the secondary axis then it's markers and error bars will
appear above and over primary axis markers and error bars.

To change the series order right click the series and pick Format Data
series.
On the Series Order tab is a listbox containing series whose order you can
swap.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Brad" wrote in message
...
For a chart with several points and lines expressed in different colors,
some often overlapping another, what determines what color is "on top" of
the other.

I have a situation where a data point market is obscured by the error bar
of something else.

Will re-ordering the data series change this? How?

My thanks in advance for any suggestions.

Cheers! Brad

Yes - the highest Plot order is on top. Right-click any series, selected
object, Series order. Changing order will also change the order shown in the
Legend.

Another approach you might consider, you can make the 'inside' or background
of markers transparent (no color). With judicious choice for the outline or
foreground of colour, size, marker style it may be possible to have several
points directly on top of one another and still be able to identify each
marker.

Regards,
Peter T


"Brad" wrote in message
...
For a chart with several points and lines expressed in different colors,
some often overlapping another, what determines what color is "on top" of
the other.

I have a situation where a data point market is obscured by the error bar
of
something else.

Will re-ordering the data series change this? How?

My thanks in advance for any suggestions.

Cheers! Brad