auto-scaling driving me crazy !!!

[francislewis]

Hi there,

I am trying to get the auto-scaling to work for an XY scatter in
excel. I have this very simple example - take the following set of
values :

1.06845 0
1.19415 0
1.19415 0.09
1.31985 0.09
1.31985 0
1.44555 0

and plot an xy scatter line - the idea being that it will produce a
right-angled graph between 1 and 1.5.
All checkboxes are set to auto calculate the axes but it insists on
putting zero as the lower value.

If anyone has any ideas i would be most grateful - hence the
exasperation in the subject line

Many thanks,

Francis.

 

[Jon Peltier]

Autoscale works differently than you expect. If the minimum value is less
than around 5/6 of the maximum value, Excel decides the minimum scale should
be zero. If you know you want 1 to 1.5, set these directly in the Format
Axis Scale dialog. Don't rely on Excel to provide your defaults.

- Jon

 

[francislewis]

Many thanks Jon. Seems like a real limitation in Excel to me as I was
creating a tool for others to use and play around with values etc. I
guess to do this I will have to delve into VBA ... zoiks !

 

[Jon Peltier]

You might start here:

http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

- Jon