Shifting Data Points

  • Thread starter Thread starter cyatkins
  • Start date Start date
C

cyatkins

I have a graph with two lines. I want to shift one of the lines to the
right, while mainitaing the origianl two lines. How do I do this.

I have data points listed in the spreadhsheet , but I want to pick up one
line graph and shift it to the right by 2 spaces, but keping the original
graph. Can anyone offer me some assistance?
 
You have to add the same small amount to each X value in the series source
data range. The easiest way to do this is by putting the small amount in
another cell, then use a formula in each cell in the X value range that adds
this cell's value to whatever was in the X value cell. This way, if you want
to adjust the offset, you can just change the value in the one cell.

- Jon
 
Back
Top