Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine stacked column and line chart w/series lines | Charts and Charting in Excel | |||
Can I link timeline labels to a line chart? | Charts and Charting in Excel | |||
COLUMN AND LINE CHARTS IN ONE CHART | Excel Discussion (Misc queries) | |||
Label an average line in a dynamic chart | Charts and Charting in Excel | |||
How do I create vertical lines in a line chart? | Charts and Charting in Excel |