AutomaticScale doesn't work properly

Hi all

a question a fellow employee has asked me earlyer:
I have two identic formatted tables, with each 2 columns
1. Column contains each Month of the last 3 years
2. Column contains Data, normal numbers without link or whatever
first table ranges from 98.8 to 109.3
second table from 100 to 136

Now i'm going to do two chart from those two tables:
first table changes into a chart where the minimum is automatically set
to 92, second table however has a minimum of 0!??
even when i change some of the numbers it stays like that!
What points does excel take into consideration for calculating the minimum
or maximum points of charts?

This problem freaks me out!!

Cheers Carlo

If the difference between high and low is more than about 1/6 of the value
of the high, Excel extends the axis all the way down to 0.

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


"Carlo" <Carlo@discussions.microsoft.com> wrote in message
news:AE3124EE-896A-4F95-B247-CEB9E63F9EBE@microsoft.com...
> Hi all
>
> a question a fellow employee has asked me earlyer:
> I have two identic formatted tables, with each 2 columns
> 1. Column contains each Month of the last 3 years
> 2. Column contains Data, normal numbers without link or whatever
> first table ranges from 98.8 to 109.3
> second table from 100 to 136
>
> Now i'm going to do two chart from those two tables:
> first table changes into a chart where the minimum is automatically set
> to 92, second table however has a minimum of 0!??
> even when i change some of the numbers it stays like that!
> What points does excel take into consideration for calculating the minimum
> or maximum points of charts?
>
> This problem freaks me out!!
>
> Cheers Carlo

That's an answer i was looking for

and as usual it's you that provides it!

Thank you

Carlo

"Jon Peltier" wrote:

> If the difference between high and low is more than about 1/6 of the value
> of the high, Excel extends the axis all the way down to 0.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> http://PeltierTech.com
> _______
>
>
> "Carlo" <Carlo@discussions.microsoft.com> wrote in message
> news:AE3124EE-896A-4F95-B247-CEB9E63F9EBE@microsoft.com...
> > Hi all
> >
> > a question a fellow employee has asked me earlyer:
> > I have two identic formatted tables, with each 2 columns
> > 1. Column contains each Month of the last 3 years
> > 2. Column contains Data, normal numbers without link or whatever
> > first table ranges from 98.8 to 109.3
> > second table from 100 to 136
> >
> > Now i'm going to do two chart from those two tables:
> > first table changes into a chart where the minimum is automatically set
> > to 92, second table however has a minimum of 0!??
> > even when i change some of the numbers it stays like that!
> > What points does excel take into consideration for calculating the minimum
> > or maximum points of charts?
> >
> > This problem freaks me out!!
> >
> > Cheers Carlo
>
>
>