To separate two line in a line chart

  • Thread starter Thread starter TRUST
  • Start date Start date
T

TRUST

Hi all,

I drew the confidence intervals (the vertical black lines) of each
points in this line chart (please see below). However, the intervals
would overlap at some places. In MS-Excel, is there any tip to shift
one of the two lines a bit horizontally? So that I can prevent the
overlapped intervals, especially as in black-and-white chart later.

Thank you!!

Seeing the figure, please click this url:
http://docs.google.com/View?docid=dgtvrqj3_10fr9frz

HsinJen Chen
 
Hi,

You would need to create a new set of x values for one of the series by
adding or subtracting a constant.

The chart type would need to be xyscatter in order to allow for
different sets of x values.

But would moving the point not have an impact on how the value was read
by the viewer of the chart?

Cheers
Andy
 
Back
Top