Autoscale axes?

External Since: Apr 02, 2004 Posts: 1

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?

Thanks
Bill

External Since: Mar 07, 2004 Posts: 2394

In article ,
(Bill) wrote:

> 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).