Excel chart does not start at zero.

I have a chart that shows shipped quantities vs month/year date, with the
date on the x-axis. My manager, who is expert at finding trivial things for
me that take up hours to accomplish, asked me to make the leftmost data point
Jan 2009, and to make the graph series line intersect with the y axis -
currently, there's a small gap between the y axis and the graph series line.

There is an option in Excel to do this: Format Axis, followed by Horizontal
Axis Crosses: Set Axis Label, which is completely busted - when I force the
axis to begin on Jan 2009, it decides to begin on Jan 2010.

Aside from getting a new manager, any suggestions?

Okay. I got it myself. Format Axis - Position Axis - On Tick Marks.



"Steven" wrote:

I have a chart that shows shipped quantities vs month/year date, with the
date on the x-axis. My manager, who is expert at finding trivial things for
me that take up hours to accomplish, asked me to make the leftmost data point
Jan 2009, and to make the graph series line intersect with the y axis -
currently, there's a small gap between the y axis and the graph series line.

There is an option in Excel to do this: Format Axis, followed by Horizontal
Axis Crosses: Set Axis Label, which is completely busted - when I force the
axis to begin on Jan 2009, it decides to begin on Jan 2010.

Aside from getting a new manager, any suggestions?