Prev: Non -matching cells
Next: Non-matching cells
From: Steven on 4 May 2010 18:50
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?
From: Steven on 5 May 2010 11:43
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?
 | 
Pages: 1
Prev: Non -matching cells
Next: Non-matching cells