A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

x-y Line Graph question



 
 
Thread Tools Display Modes
  #1  
Old February 1st, 2006, 07:45 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default x-y Line Graph question

I have a line graph. X is dates and Y is numeric data. I am plotting
12/1/2005 through 1/30/2006. The problems is my series does not start at the
"left most" point of 12/1/2005, it is shifted slightly. And the line does
not end at the "right most" point of 1/30/2006.

Any ideas will be appreciated. thanks!
  #2  
Old February 1st, 2006, 11:05 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default x-y Line Graph question

XL has two distinct chart types even though they look similar, the XY
Scatter chart and the Line chart. There is no XY Line graph.

I believe you have a Line graph. Double-click the x-axis and from the Scale
tab uncheck the 'Value (Y) axis crosses between dates' checkbox.

Alternatively, if the scale tab has fields for Min. / Max. values you may
want to adjust those.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I have a line graph. X is dates and Y is numeric data. I am plotting
12/1/2005 through 1/30/2006. The problems is my series does not start at the
"left most" point of 12/1/2005, it is shifted slightly. And the line does
not end at the "right most" point of 1/30/2006.

Any ideas will be appreciated. thanks!

  #3  
Old February 2nd, 2006, 01:14 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default x-y Line Graph question

this works . thanks for the tip

"Tushar Mehta" wrote:

XL has two distinct chart types even though they look similar, the XY
Scatter chart and the Line chart. There is no XY Line graph.

I believe you have a Line graph. Double-click the x-axis and from the Scale
tab uncheck the 'Value (Y) axis crosses between dates' checkbox.

Alternatively, if the scale tab has fields for Min. / Max. values you may
want to adjust those.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I have a line graph. X is dates and Y is numeric data. I am plotting
12/1/2005 through 1/30/2006. The problems is my series does not start at the
"left most" point of 12/1/2005, it is shifted slightly. And the line does
not end at the "right most" point of 1/30/2006.

Any ideas will be appreciated. thanks!


  #4  
Old February 2nd, 2006, 01:37 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default x-y Line Graph question

In article ,
says...
this works . thanks for the tip

You are welcome.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Line Graph Help mickeymouse Charts and Charting 2 January 27th, 2006 09:39 AM
Survey Results SAm Running & Setting Up Queries 10 May 17th, 2005 08:32 PM
Line Graph Data Recognition Nat Charts and Charting 2 April 30th, 2005 02:07 PM
Convert a line to a bar in a line-bar graph Julie L Powerpoint 1 April 21st, 2005 11:40 PM
help with line graph darci Charts and Charting 1 February 22nd, 2004 01:52 PM


All times are GMT +1. The time now is 10:45 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.