overlaping lines in a chart

[Jared]

Is there a way to get more than one line to appear on the
line chart when they both have the same values at certain
points? I have a chart where three lines occupy the same
values at 2 points on the X-axis and I want all three
colors to show up on that segment.

 

[Jon Peltier]

Jared -

I've used various techniques for this. One is jiggling the values of the
points, so their values are Y+0.01, Y-0.01, and Y (use appropriate
offsets, if 0.01 isn't good). Another is to make the bottom line thick,
and the others increasingly thin; this is pretty ugly. A third is to
make the bottom one a solid line, the middle one a long-and-short dashed
line, and the top one a short dashed line; also ugly but not as bad.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______