LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Ker Ker is offline
external usenet poster
 
Posts: 2
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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart not visible -suspect scale setting? Big Mac Charts and Charting in Excel 0 March 12th 07 01:40 PM
Setting chart scale min/max in VBA [email protected] Charts and Charting in Excel 2 January 30th 07 09:11 PM
Setting up slide scale for prices Ted Metro Excel Worksheet Functions 2 January 4th 07 09:46 PM
Setting rules for y scale nospaminlich Charts and Charting in Excel 2 May 23rd 06 12:31 PM
Setting the X axis scale/font CLR Charts and Charting in Excel 2 February 13th 05 08:32 PM


All times are GMT +1. The time now is 08:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"