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!

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 <[email protected]>,
[email protected] 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!
>

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 <[email protected]>,
> [email protected] 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!
> >
>

In article <[email protected]>,
[email protected] 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