I've suggested this, but it lies in the "Don't hold your breath" category.
What you can do, if you always want the axis to lie at the bottom, is to set
a ridiculously low value for "Crosses At", like -1E300 (or 1E-300 for a log
scale). If the axis minimum is greater than this number, Excel uses the
minimum. Since you've selected such a low number, the minimum should always
be above your number.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
>I think that almost always I want the X axis values and label at the BOTTOM
> of the plot.
[quoted text clipped - 12 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=c0836d74-5fce-4
1a9-ba4a-3a695ee632b1&dg=microsoft.public.excel.charting