A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Chart setting scale



 
 
Thread Tools Display Modes
  #1  
Old March 11th, 2009, 01:44 AM posted to microsoft.public.excel.charting
KER
external usenet poster
 
Posts: 4
Default 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  
Old March 11th, 2009, 10:01 AM posted to microsoft.public.excel.charting
David Biddulph
external usenet poster
 
Posts: 8,714
Default 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  
Old March 11th, 2009, 01:49 PM posted to microsoft.public.excel.charting
KER
external usenet poster
 
Posts: 4
Default 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  
Old March 11th, 2009, 04:28 PM posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
 
Posts: 5,018
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.