Excel 2007 : Histograms: Y-axis elsewhere than at X-axis zero?

[rtw0501]

I'm doing a bunch of histograms of variable distributions for a dissertation. They're perfect for showing distributions, but one of my variables has positive AND negative values.

Problem is, the histogram automatically places the Y-axis at zero on the X-axis, which is right in the middle of my histogram (overlaying bins, etc.).

I want my Y-axis at, say, -10 on the X-axis. But it won't drag over there, and I can't find an option that asks where I want it.

I'd appreciate any help.

rtw0501

[zbor]

Right click on X axis numbers -> Format axis -> Vertical axis crosses: Write minimum number of X in the box

[shg]

Select the x axis, on the Layout tab select Format Selection, in Axis Options see the Vertical axis crosses section

[rtw0501]

Thanks a bunch, shg and zbor. Works perfectly.