AutomaticScale doesn't work properly

[Carlo]

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

 

[Jon Peltier]

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

 

[Carlo]

That's an answer i was looking for

and as usual it's you that provides it!

Thank you

Carlo