| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can a value axis autoscale to something other than 0 for the min?
I know how to manually change the scale on a value axis, but is there a way
to have the autoscale function automatically maximize the data in the chart? This is for a dynamic chart that can change when certain selection items are chosen from drop-down menus. For example, one set of data ranges from 6 to 9, so I would want the scale to be 5 to 10. Then, the selections change, and the data displayed in the chart now ranges from 31 to 39. I want the scale to be 30 to 40, not 0 to 40. Can this be done? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| how to add a second x axis with same Y axis value in one plot | Charts and Charting in Excel | |||
| Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
| Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
| can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
Threaded Mode
