Apple Numbers '09 - Manual (Page 147)

Chapter 7 Creating Charts from Data 147
Number: Displays the data point value with no units, unless you specify them. To
specify units, type them into the Suffix field. In the Decimals field, specify how many
decimal places you want to appear, and then choose –100 or (100) from the adjacent
pop-up menu to choose a style for displaying negative numbers. Select Separator if
you want to show a thousands separator on the left side of the decimal.
Currency: Displays the data point value as a monetary amount. Choose the currency
unit symbol from the Symbol pop-up menu. In the Decimals field, specify how many
decimal places you want to appear. To display negative values preceded by a minus
sign or in parentheses, choose –100 or (100) from the pop-up menu. Select Separator if
you want to show a thousands separator on the left side of the decimal.
Percentage: Displays the data point value as divided by 100. In the Decimals field,
specify how many decimal places you want to appear. To display negative values
preceded by a minus sign or in parentheses, choose –100 or (100) from the pop-up
menu. Select Separator if you want to show a thousands separator on the left side of
the decimal.
Date and Time: Displays data point values with a date and time format.
Duration: Displays data point values as a unit of time (for example, seconds, minutes,
or weeks).
Fraction: Displays data point values less than 1 as one integer over another. (If your
values are greater than 1, you won’t see any fractional representation of your data.)
Select how accurately you want the fractions rounded in the Accuracy pop-up menu.
Selecting an option such as Halves or Quarters represents the values as a portion of
the total pie, rounded to the nearest division you selected.
Scientific: Displays data point values in scientific notation, where 10 raised to a power
is represented as E+ an integer. In the Decimals field, specify how many decimal places
you want to show.
Custom: Select a custom number format you’ve already created, or create a new one.
See “Using Your Own Formats for Displaying Values in Table Cells” on page 101 for
more information.
To display category (data set) titles:
1 Choose Show Categories from the Choose Axis Options pop-up menu under Category
Axis in the Axis pane of the Chart inspector.
2 To change the category labels, insert the pointer in the Labels field, do one of the
following, and then click the Accept button (the green check) to save your changes:
To include a label, click the cell of the table where the label you want appears. Â
A reference to the cell is added to the Labels field.
To exclude a label, select the cell reference in the Label field and press the
Â
Delete key.