AutomaticScale doesn't work properly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
That's an answer i was looking for :)

and as usual it's you that provides it!

Thank you

Carlo
 
Back
Top