Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
bmeril
 
Posts: n/a
Default 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.
  #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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting a new line when external data changes Rental Man Excel Discussion (Misc queries) 0 January 11th 06 07:05 PM
create a chart using two columns for x & y, third for line data Ted K Charts and Charting in Excel 3 November 11th 05 01:39 AM
Charts not recognizing source data if original linked data is changed. JLC Charts and Charting in Excel 3 October 14th 05 01:29 AM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
How can I get 7.3 million data pts on one line graph? tobesus Excel Discussion (Misc queries) 2 April 22nd 05 01:16 AM


All times are GMT +1. The time now is 11:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"