Defining the Number Format for Chart Data Values

You can either use grid number formatting for chart data values or you can customize how numbers are formatted. Grid formatting means that chart formatting reflects the cell formatting of the first cell in the grid. Deselecting the grid formatting option allows you to customize the number format used in the chart.

To define a customized number format:
  1. Open a report and select a chart.
  2. In Chart Properties, click Format Chart button.
  3. Depending on the type of chart, select the Bar Options, Line Options, or Pie Options, tab, and then do one of the following:
    • In the Bar Options or Line Options tab, deselect Use Grid Formatting, and then click Number button.
    • In the Pie Options tab, select Data under Show Slice Value As and deselect Use Grid Formatting, and then click Number button.
  4. In the Format Numbers dialog box, define information about the number format, and then click OK.