Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Chart not visible -suspect scale setting? | Charts and Charting in Excel | |||
Setting chart scale min/max in VBA | Charts and Charting in Excel | |||
Setting up slide scale for prices | Excel Worksheet Functions | |||
Setting rules for y scale | Charts and Charting in Excel | |||
Setting the X axis scale/font | Charts and Charting in Excel |