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?