x-y Line Graph question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
this works . thanks for the tip

Tushar Mehta said:
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
Click to expand...
 
Back
Top