Font Format dialog: Number Format tab

Use this tab of the "Font Format: Item dialog" to override the default numeric format in which data labels are currently displayed.

Note:

The numeric format is inherited from the representative column in the Criteria tab. If two or more columns are selected for the same axis, then numeric formatting is not inherited.

For more information, see:

This dialog is also displayed as:

Format: Item dialog: Number Format tab

Components

Override Default Data Format

Use this box to specify that you want override the default numeric format in which data labels are currently displayed.

Treat Numbers As

Use this box to specify whether data labels are numbers, percentages, or currency.

Currency Symbol

This box is available only if you select Currency in the Treat Numbers As box.

Use this box to select the currency symbol to show in data labels.

Negative Format

Use this option to specify whether to display negative data labels using a minus sign (for example, -123) or parentheses (for example, (123).

Decimal Places

Use this box to select the number of decimal places (to a maximum of 6) in which to display numbers (for example, 120,000,000.000).

Use 1000's Separator

Use this box to specify whether to separate each magnitude of a thousand by a comma. (for example, 1,000,000,000.00