Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / August 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Chadillac - 07 Aug 2006 19:02 GMT
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.
Jon Peltier - 08 Aug 2006 00:39 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.