Thread: Should allow: "Value (X) axis crosses at *-MINIMUM-* value

I think that almost always I want the X axis values and label at the BOTTOM
of the plot.

There is an option for them to be at the top. Why not the bottom??

MS could put in a button for max or min value.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

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
_______


"Chadillac" <Chadillac@discussions.microsoft.com> wrote in message
news:C0836D74-5FCE-41A9-BA4A-3A695EE632B1@microsoft.com...
>I think that almost always I want the X axis values and label at the BOTTOM
> of the plot.
>
> There is an option for them to be at the top. Why not the bottom??
>
> MS could put in a button for max or min value.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow
> this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...excel.charting

Has MS ever provided an official reply as to why they have NOT included an "x axis crosses at min value" option, but did provide one for max value?
I'm using the latest version of Excel, and it still doesn't have this button, and the last post in this thread was from back in 2006.
MS FAIL!