LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Should allow: "Value (X) axis crosses at *-MINIMUM-* value

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" wrote in message
...
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't Set Minimum Y Axis Values annem Excel Worksheet Functions 3 November 21st 07 04:34 PM
Auto minimum on Y Axis mattjenkins Charts and Charting in Excel 4 July 5th 06 04:28 PM
Value (Y) axis crosses between dates Frager Charts and Charting in Excel 2 January 17th 06 11:13 PM
Secondary Axis Match Primary Axis Gridlines [email protected] Charts and Charting in Excel 1 July 31st 05 09:23 PM
Hiding Values Below Z Axis Minimum Value on Axis Charts TryingToExcel Charts and Charting in Excel 1 February 18th 05 03:55 AM


All times are GMT +1. The time now is 08:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"