+ Reply to Thread
Results 1 to 2 of 2

Lines are hidden on line chart

  1. #1
    FuadsCurse
    Guest

    Lines are hidden on line chart

    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.



  2. #2
    HEK
    Guest

    RE: Lines are hidden on line chart

    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

    "FuadsCurse" wrote:

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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1