Lines are hidden on line chart

F

FuadsCurse

Is there any way to differentiate lines that are on top of each other? That
is, they have similar data at some point on the chart. I've got a time-scale
line chart - so it's a step chart and some of the data for the two lines I've
got are the same. On the chart, all you see is one line - I'm just trying to
determine if there is a way to differentiate them ... thanks.
 
H

HEK

Coinciding lines are overlapping by default. Line widths are limited in
Excel (will be btter in Excel 2007) and this is likely not a sensible option.
Maybe you can use clearly discriminating dots (a.g. a small solid dot for
line A and a large open circle dot for line 2 so the coinciding dots are both
clearly visible?
Another trick that MIGHT be helpful is to deliberately shift the second line
slightly upwards by adding a relatively small value to the Y-value. This can
be good if you are just interested in pattern and trends, but won't be smart
in case you need to accurately read the values from the chart. Also the shift
may suggest a difference that isn't there so be cautious when using this
"trick".

HTH,
GL,
Henk
 

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