Spreading apart lines on a scatter plot

[Billy Wilton]

Hi, I'm trying to add a constant value to the each data
point in my chart so as to sread the two lines apart so
that it's easier to compare and interpret them. Is there
an easy was to do this

 

[Frank Kabel]

Hi Billy
why not create a helper column in your sorce data, adding a constant
value to the original value and use this helper column as source for
your chart?

 

[Jon Peltier]

To make it easier, I usually set up columns like this (suppose this
shows A1:E2):

-0.1 +0.1
X Y1 Y2 Y1' Y2'

In D3 I put a formula like this:

=$B3+D$1

which I fill right and down as far as needed. This offsets Y1 and Y2
apart from each other slightly, and I can easily change both columns by
simply changing the values in D1 and E1. In fact, I often just put an
offset value in E1, and the formula =-E1 into cell D1.

Then I plot columns D and E vs. column A.

- Jon