You can make the x-axis cross at the maximum Y-value, but is it possible (without macro) to make it cross at the minimum value?
I should find that much more useful.
NSV
You can make the x-axis cross at the maximum Y-value, but is it possible (without macro) to make it cross at the minimum value?
I should find that much more useful.
NSV
When this is an issue for me, I just use some value <= the minimum Y axis value that the data will ever see. So, if my Y data will always be positive, I set the X axis crosses at 0, and the x axis is always at the bottom of the plot.
Taking it to the extreme, enter a value that's ridiculously less than the
minimum. Say, -999999999999 for a linear scale, or 0.000000001 for a log
scale. Almost as helpful as a button would have been.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______
"MrShorty" <[email protected]> wrote in
message news:[email protected]...
>
> When this is an issue for me, I just use some value <= the minimum Y
> axis value that the data will ever see. So, if my Y data will always
> be positive, I set the X axis crosses at 0, and the x axis is always at
> the bottom of the plot.
>
>
> --
> MrShorty
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks