How do i change the axis location on a chart that has negative da.

[Guest]

I am charting data on a line chart that is negative. The x axis catagories
are displayed below the zero line, but not below that last line of data.
How do i move the catagories below the last line of data.
I have used the offset but it only allows up to 1000. This isnt enough.

 

[Jon Peltier]

You can leave the axis where it is, in fact, for a column chart moving the X axis
will change the origin of the columns. Double click the X axis, and on the Patterns
tab, for Tick Labels, choose the Low position.

To move the axis itself, double click the Y axis, and on the Scale tab, change the
Category Axis Crosses At setting. Don't worry about choosing the exact minimum of
the Y axis, because it might change, and then you'll have to reset this value.
Instead, pick a ridiculously negative value, like -100000000000. The minimum is not
affected by this setting, so the axis will always be at the bottom of the chart.

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