The Format property is used to format the contents of the label. The full path for this property is Area.Axis.Labels.Format. This property has multiple values.

numbers. The N value of the Format property is used for general representation of numbers. When filling out the Format, you can specify the number of decimal places to use after the N value. If no number is specified after N, it will only be displayed if there are digits after the decimal point in the result of the calculation. Below is a chart with the "Series Label" "Format" property set to "N".

 currency. The C value of the Format property is used to display labels with currency symbols. The C value allows you to specify the number of decimal places to use. Below is a chart with the "Series Label" Format property set to C.

 percentage. The P value of the Format property is used to display the percent sign in the label. After the p-value you can specify the number of decimal places to use. Below is a chart with the "Series Label" Format property set to P.

 Date formatting. The MM/dd/yyyy, MMMM dd, yyyy MMMM value of the Format property converts the argument value to a date. MM/dd/yyyy – looks like “01.20.2010”, MMMM dd – looks like “September 29th”, yyyy MMMM – looks like “2010 March”. The image below shows the chart's Format property set to MM/dd/yyyy.

To reset the Format property of selected cells back to the default formatting, select an empty field and clear the formatting.