If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|