Lines are hidden on line chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top