Selecting the scale factor

The scale factor is the "divide-by" factor to trim axis scale labels. This option is useful when there are large data values. This option does not affect the data, only the appearance of the scale labels.

You may want to set an axis title that indicates the scale factor is being used.

To select the scale factor:

  1. On the Chart tab, in the Axes group, click Scale Factor More to expand the list.
  2. Select the scale factor. You may want to set an appropriate axis title indicating a scale factor is being used. You can factor the scale by:
    • 1 disables the scale factor
    • 1,000 (thousands)
    • 1,000,000 (millions)
    • 1,000,000,000 (billions)
  3. Click Save Changes.