Thread: auto-scaling driving me crazy !!!

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
_______


<francislewis@btconnect.com> wrote in message
news:1153924116.473461.161210@s13g2000cwa.googlegroups.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
> _______
>
>
> <francislewis@btconnect.com> wrote in message
> news:1153924116.473461.161210@s13g2000cwa.googlegroups.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 here:

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

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


<francislewis@btconnect.com> wrote in message
news:1155545330.848740.149260@m79g2000cwm.googlegroups.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
>> _______
>>
>>
>> <francislewis@btconnect.com> wrote in message
>> news:1153924116.473461.161210@s13g2000cwa.googlegroups.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.
>> >
>