Thank-you for your response. I have read the MSKB article to which you refer
(214075), and it seems that XL is not behaving as randomly as I first
thought. The part that seems to be causing me problems is:

"If the difference between yMax and yMin is greater than 16.667 percent of
the value of yMax, the automatic minimum for the y-axis is zero."

I would like to have XL effectively ignore this 'if' statement in the
algorithm, so that the axis minimum is always set to the first Major division
less than or equal to yMin. I do not have much experience with XL coding -
would anyone be able to give me some pointers as to where I might begin
editing the algorithm, if this is even possible?

"Tushar Mehta" wrote:

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