Chart setting scale
 

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?

Chart setting scale
 

Format Axis/ Scale.
--
David Biddulph

Ker wrote:
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?

Chart setting scale
 

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.

"David Biddulph" wrote:

Format Axis/ Scale.
--
David Biddulph

Ker wrote:
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?

Chart setting scale
 

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


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

"David Biddulph" wrote:

Format Axis/ Scale.
--
David Biddulph

Ker wrote:
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?