Shifting the position of x-axis labels
 

When you have data within Excel that generates negative values, the
labels on the x-axis are typically generated such that they occur in
the middle of your graph. Basically, Excel assumes that your x-axis
must occur at 0 on your axis.

Is there anyway to move your x-axis to occur at some y-axis value below
0? That way ensuring that the x-axis will not obstruct the graph?

Shifting the position of x-axis labels
 

Double click on the axis, and on the Patterns tab, for Tick labels, choose
the Low option.

Alternatively, pick the other axis, and enter a better value for Crosses At.
You don't need to use the actual axis minimum: if it currently has a minimum
of -2 and you think it might drop lower, use -2000000. This value is not
used to set the minimum, but only the place where the other axis crosses.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"den1s" wrote in message
oups.com...
When you have data within Excel that generates negative values, the
labels on the x-axis are typically generated such that they occur in
the middle of your graph. Basically, Excel assumes that your x-axis
must occur at 0 on your axis.

Is there anyway to move your x-axis to occur at some y-axis value below
0? That way ensuring that the x-axis will not obstruct the graph?