Charting Data and Automating Tasks

Charting Data

Creating Pie Charts

Overview of Chart Tools

Changing a Chart’s Location

Moving and Resizing Charts

Moving Charts

Resizing Charts

Adding Chart Titles and Labels

Formatting Chart Objects

Previewing and Printing Charts

Creating Column or Bar Charts

Changing the Numbering Scale

Changing the Data Series to Rows or Columns

Working with Trendlines

Adding Data to Charts

Creating Macros

Using Conditional Formatting

Applying Preset Conditional Formatting Rules

Editing Conditional Formatting Rules

Creating Basic Macros

Running Macros

Editing Macros

Deleting Macros

Adding Macro Buttons to the Toolbar

Filling a Series

Using the Fill Handle to Copy and Paste

Filling Number Series by Example

Filling a Date Series

Using AutoFill

Using Predefined Custom Lists

Creating Custom Lists

Importing Lists