To separate two line in a line chart
 

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

To separate two line in a line chart
 

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

TRUST wrote:
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


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

To separate two line in a line chart
 

Hello Andy,

Your suggestion is useful.
I have obtained the chart I want.
Please see this (http://docs.google.com/View?docid=dgtvrqj3_10fr9frz)
for detailed solutions.
Thanks a lot!!

Best wishes,

Hsin-Jen


Andy Pope wrote:

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

TRUST wrote:
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


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info