Overide Excel Chart Auto Min/Max Values

[patsfan]

Is there a way to overide a chart's axis auto-set values with a formula or cell reference? I frequently need to "display units in thousands" and the minimum chart axis seems to always defaults to zero and the maximium axis defaults to just above the maximum series value . An example would be a chart with all data values between 400,000 and 500,000. Excel axis default is from 0 to 600,000. I would prefer the axis minimum be closer to the series minimum, thus providing clearer visibility to data variances. Thanks

 

[Luke M]

This is the closest I've been able to use:
http://peltiertech.com/WordPress/link-excel-chart-axis-scale-to-values-in-cells/

 

[patsfan]

Thanks Luke. I appreciate the quick response.