Number options

Use these options to change the number format of numbers that are used on the value axis or in the data labels of your chart.

Category     Click an option in the Category box, and then select the format that you want to apply.

Decimal places     Specify up to 30 decimal places. This box is available only for the Number, Currency, Accounting, Percentage, and Scientific categories.

Use 1000 Separator (,)     Select this check box to insert a thousand separator. This check box is available only for the Number category.

Negative numbers     Specify the format in which you want negative numbers to be displayed. This option is available only for the Number and Currency categories.

Symbol     Select the currency symbol that you want to use. This box is available only for the Currency and Accounting categories.

Type     Select the display type that you want to use for a number. This list box is available only for the Date, Time, Fraction, Special, and Custom categories.

Locale (location)     Select a different language that you want to use for the display type of a number. This option is available only for the Date, Time, and Special categories.

Format Code     Allows you to create a custom number format. In the Format Code box, make the changes that you want to the currently selected number format, or select this number format, and then type your own custom number format. Click Add to apply the custom number format to the chart.

Add     Allows you to apply a custom number format to the chart.

Delete     Allows you to delete a custom number format. This option is available only after you create a custom number format.

Linked To Source     Select this check box if you want to reference corresponding numbers on the worksheet.