Spreading apart lines on a scatter plot

  • Thread starter Thread starter Billy Wilton
  • Start date Start date
B

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
 
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?
 
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
 
Back
Top