Formatting Chart Numbers

By default, the number format displayed on the forecast chart comes from the underlying format of the forecast cell. You can select another cell format using the Chart Preferences dialog.

  To change the format of numbers in a forecast chart:

  1. In the forecast window, select Preferences, and then Chart.

  2. In the Chart Preferences dialog, click the Axis tab.

  3. Select a format from the drop-down list in the Format Number group. Formats are similar to Microsoft Excel formats. For most formats, you can specify the number of decimal places and whether to use a thousands separator.

  4. Click OK or use Apply To to create a default, as described in Applying Settings to Multiple Charts.