Chart setting scale

[Ker]

The chart is set up to allow the user to select which Geo they want to show
and it automatically refreshes. For most of the Geos, the scale
automatically sets to narrow in based on the minimum and maximum values shown
but for some of the Geos, the scale defaults to go from 0 to 100.

Geo info is pulled from the exact same chart but point to different cells
for their source data. After further investigation, I found that if a Geo
ever had a value below 74.834%, then the scale starts at 0 and goes up to
100. If all the values are above 74.834%, then the chart will automatically
set the range to narrow in on the values.

Ideally, we would like the y-axis scale to narrow in on the data shown. Does
anyone have any ideas?

 

[Ker]

I look at format axis (I'm using vista) and everything is set to automatic
but still now working correctly for those values less than 74.834.

 

[Jon Peltier]

If the range between max and min exceeds 1/6 of the max, then Excel
automatically sets the minimum to zero. You may have to override the scale
settings.

- Jon