View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Color "on top" determined how?

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