close

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--
nsv
------------------------------------------------------------------------
nsv's Profile: www.excelforum.com/member.php...oamp;userid=26500
View this thread: www.excelforum.com/showthread...hreadid=526722
When this is an issue for me, I just use some value lt;= 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
------------------------------------------------------------------------
MrShorty's Profile: www.excelforum.com/member.php...oamp;userid=22181
View this thread: www.excelforum.com/showthread...hreadid=526722Taking 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 -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;MrShortyquot; gt; wrote in
message ...
gt;
gt; When this is an issue for me, I just use some value lt;= the minimum Y
gt; axis value that the data will ever see. So, if my Y data will always
gt; be positive, I set the X axis crosses at 0, and the x axis is always at
gt; the bottom of the plot.
gt;
gt;
gt; --
gt; MrShorty

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()