View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default How can I shift my data line to the left?

If it's an XY chart, simply add a constant to each X value.

If it's a Line chart, you have to include some empty cells at the beginning
of the source data range.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"bmeril" wrote in message
...
How can I shift my data point line to the left. I want the line to start
at
the 3rd position of the x-axis and not at the y-axis.