auto-scaling driving me crazy !!!

  • Thread starter Thread starter francislewis
  • Start date Start date
F

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.
 
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
 
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 !
 
Back
Top