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?


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question