08

Table Of Contents
Contents 9
13 6 Performing a Basic Calculation Using Row Values
13 6 Removing a Formula
137 Using the Formula Editor
137 Adding a New Formula with the Formula Editor
13 8 Editing a Formula with the Formula Editor
13 8 Using Cell References
13 8 Adding Cell References to a Formula
13 9 Copying or Moving Formulas with Cell References
13 9 Applying a Formula Once to Cells in a Column or Row
140 Handling Errors and Warnings
140 Using Operators
140 Performing Arithmetic Operations
141 Understanding the Arithmetic Operators
142 Understanding the Comparison Operators
143 Using Functions
Chapter 8 144 Using Charts
144 About Charts
146 Adding a Chart
147 Selecting a Chart Type
147 Picking an Initial Chart Type
148 Changing a Chart from One Type to Another
149 Editing Chart Data
149 Copying Data into the Chart Data Editor
149 Working with Rows and Columns in the Chart Data Editor
150 Formatting General Chart Attributes
150 Using a Legend
151 Using a Chart Title
151 Resizing a Chart
151 Rotating Charts
152 Adding Labels and Axis Markings
152 Showing Axes and Borders
152 Using Axis Titles
153 Showing Data Point Labels
153 Formatting the Value Axis
154 Placing Labels, Gridlines, and Tick Marks
155 Formatting the Elements in a Data Series
156 Formatting Titles, Labels, and Legends
156 Adding Descriptive Text to a Chart
156 Formatting Specific Types of Charts
156 Pie Charts
157 Selecting Individual Pie Wedges
157 Showing a Series Name in a Pie Chart