Is there a way to have a chart's axes automatically scale (e.g. 0-10,
0-50, 0-4) depending on the range of the data?
Autoscaling is the default behavior for XL charts. If the axis doesn't
autoscale, ctrl-click on the axis, choose Format Axis, select the Scale
tab, and make sure that the Auto checkboxes are checked, at least on
Maximum.
You can't set varying increments for autoscale, but selecting a fixed
major unit will make all autoscales use that increment (e.g. if the
major unit is 20, then the axis will scale from 0-20 to 0-40, even if
the values would otherwise autoscale to 0-30, say).
