View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
steven steven is offline
external usenet poster
 
Posts: 389
Default Excel chart does not start at zero.

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?