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

AutomaticScale doesn't work properly
 

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

AutomaticScale doesn't work properly
 

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