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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


wrote in message
oups.com...
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.

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 wrote:
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


wrote in message
oups.com...
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.

You might start he

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


wrote in message
oups.com...
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 wrote:
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


wrote in message
oups.com...
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.