x-y Line Graph question

[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!

 

[Tushar Mehta]

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

 

[Guest]

this works . thanks for the tip

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

 

[Tushar Mehta]

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