ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How can I shift my data line to the left? (https://www.excelbanter.com/charts-charting-excel/66282-how-can-i-shift-my-data-line-left.html)

bmeril

How can I shift my data line to the left?
 
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.

Jon Peltier

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.





All times are GMT +1. The time now is 08:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com