User Guide

2-axis charts 15 8
A
absolute cell references 12 6
Address Book
adding Address Book data to a new table 232
adding Address Book data to an existing
table 231
adding vCard data to a new table 232
adding vCard data to an existing table 231
mapping column names to eld names 229
Adjust Image window 196
alignment guides
creating your own 214
using 213
area charts 15 7
arithmetic operators 12 7
arrow shapes 203
audio. See sound
autolling 78
automatic cell format 88
B
bar charts 15 5
borders
around objects 218
of table cells 84
C
calculations, instant 116
categories and subcategories
category rows 66
category value columns 66
creating 67
displaying calculated values 72
managing 72
moving rows among 72
moving up or down levels 72
removing 72
category axis 14 2
cell controls 96
cell formats 86
cell references
distinguishing absolute and relative 12 6
inserting into formulas 12 5
Cells inspector 46
charts
about 131
adding more data 137
changing plotting orientation 137
changing the type 13 5
creating from table data 13 4
customizing 2-axis and mixed charts 15 8
customizing area charts 15 7
customizing bar and column charts 15 5
customizing line charts 15 6
customizing pie charts 151
deleting 140
formatting axes 142
formatting elements in a data series 145
formatting text of titles, labels, and legends 15 0
formatting title and legend 141
including hidden table data 13 8
linking to from Pages and Keynote 14 0
moving 13 6
removing data from 139
replacing or reordering data series 138
resizing or rotating 141
showing error bars 148
showing trendlines 149
using scatter charts 15 7
checkboxes. See cell controls
clipping 79
Colors window 24
column charts 15 5
columns
adding 57
deleting 58
hiding 63
rearranging 58
resizing 62
See also tables
comments in table cells 86
comparison operators 127
conditional formatting
changing and managing 82
Index
247
Index