Color "on top" determined how?

B

Brad

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
 
A

Andy Pope

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
 
P

Peter T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top