There is a MSKB article that explains how XL sets the scaling of a chart
axis. From what I remember, it referred to XL5 or something like that but
if you are interested search msdn.microsoft.com and support.microsoft.com

As far as solving it goes, you would have to use code. Either write your
own routine that sets the axis max. and min. scales based on your own
algorithm (maybe the value in some cell?) or use a ready-made solution such
as
AutoChart Manager
http://www.tushar-mehta.com/excel/so...art/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , rpsummers
says...
I have found that when producing XY scatter charts, the scale on the Y-axisis
not always auto-scaled to a sensible range. For example, I had a chart where
all the data points were between 195 and 250 on the Y axis. Instead of
auto-scaling the axis to run from 190 to 255 (approx) as expected, the Y axis
runs all the way down to zero, leaving a relatively large blank area on the
chart. I have tried changing the 'Format Axis' options, and ensured that
'Auto' was checked in all cases. Exponential scales are inappropriate for
this application.

In another chart however, where the data range was slightly smaller, (all
points between 210 and 250), Excel elected to sensibly auto-scale the Y axis
so that it only ran from 205 to 255, and the plot fills the chart area and is
easier to read. I would like this to happen with all my charts.

Can anyone explain what might be causing this inconsistency or suggest how i
might 'fix' the auto-scaling of axes.

Thanks