View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Shifting Data Points

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"cyatkins" wrote in message
...
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?