The last reply was the "ideal" solution to my problem. As the Y-values
do represent percentages growth or decline and the decline couldn't be
more than 100%, there is an absolute minimum to the scale.
The nice thing about the solution is that if the minimum data value is
e.g. -40%, the Y-scale doesn't extend to -100%.
Thanks.
--
rvExcelNewTip
------------------------------------------------------------------------
rvExcelNewTip's Profile:
http://www.excelforum.com/member.php...o&userid=15668
View this thread:
http://www.excelforum.com/showthread...hreadid=376715