Learning excel

  • Thread starter Thread starter Simbie Le
  • Start date Start date
S

Simbie Le

I am sorry for the basic question but this has been in my head for days
unresolved.
Below is a set of data I have obtained from my experiment at school

(x,y)={(1,1)(2,2)(3,2),(4,3),(5,2)(6,3)(7,1)}

I am using excel to draw a straight lined graph with those points but I
am wondering is there any command to be input from the above "f"'s text
box to redraw the graph when I would like to move it parallel to the x
axis 5 units

In the above co-ordinates I used only a monotonic increasing x value of
1 unit. In a more complex case, I need use increasingly different values.

Any help is appreciated.
 
Charts use only the data you give them. There is no magic command to make
them plot something you didn't give them.

To get an offset, use formulas to add the offset to the data.

Your data:

1 1
2 2
3 2
4 3
5 2
6 3
7 1

Insert a column between these. I'll assume the inserted column is column B,
and your X data is in A3:A9. In B1 enter the value you want to offset the
data by, say 5. In B3 enter this formula

=A3+B$1

and drag this down the column. It will now look like this:

1 6 1
2 7 2
3 8 2
4 9 3
5 10 2
6 11 3
7 12 1

Now make the plot with the rightmost two columns.

- Jon
 
Back
Top