Specifying Labels chart format options

Labels chart format options control whether the labels of an axis are displayed and how they are formatted.

1. On the Format page of the New Chart wizard, expand the Axes node.
2. Expand the X-Axis or Y-Axis node and select Labels in the tree.
   The Labels options are displayed.
3. To display the labels of an axis, select the Visible check box.
4. Specify the font of the axis labels in the Font field.
5. Click the ellipsis (...) next to the Format field.
   The Choose a format window opens.
6. Select the format of the column cell values from the Format list.
   The following formats are available for numeric data type:

   • As is - The exact value of the column is displayed without any formatting.
   • Currency - Column values are displayed as currency. The locale settings of the current session determine the currency unit that is displayed.
   • Decimal - Column values are displayed as decimals.
   • Scientific - Column values are displayed in scientific notation.
   • Percent - Column values are displayed as percentages.
   • Custom - Data point values are displayed according to the pattern that you specified in the Pattern field.

   The following formats are available for date data type:

   • As is - The exact value of the column is displayed without any formatting.
   • Database - The date is displayed in the format of the database.
   • Date - Select the date presentation from the available formats.
   • Custom - The date is displayed according to the pattern that you specified in the Pattern field.

   The following formats are available for timestamp data type:

   • As is - The exact value of the column is displayed without any formatting.
   • Database - The timestamp is displayed in the format of the database.
   • Timestamp - Select the timestamp presentation from the available formats.
   • Date - Only the date component of the timestamp is displayed.
   • Time - Only the time component of the timestamp is displayed.
   • Custom - The timestamp is displayed according to the pattern that you specified in the Pattern field.
7. To include thousands separators with column values, select the Thousands separator check box.
8. Specify the number of decimal places that are displayed in the Decimal places field.
   A value of '0' indicates that no decimal places are displayed.
9. Click OK to close the Choose a format dialog.
10. Specify the angle of the labels of the axis in the Rotation field.
    A value of '0' indicates no rotation. Labels are displayed with no angle. Higher numbers indicate higher angles. Values can be both positive and negative. Positive numbers turn labels counter clockwise and negative values turn labels clockwise.