Shifting the position of x-axis labels

D

den1s

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?
 
J

Jon Peltier

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
 

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

Similar Threads

Make Y-axis values correspond to x- axis value 1
X-axis labels in charts 1
Setting axis labels 5
X-Axis labels 1
Position of X axis labels 4
chart x axis labels show up as range 1
Data labels along below x axis when y axis has negative values 1
Line Chart - Problems with labeling X-Axis 3

Top