Charting Data and Automating Tasks

Using Microsoft Excel

3 Hours
Versions 2003 or 2007

Charting Data in Excel

Creating Pie Charts

Moving and Resizing Charts

Important Charting Notes

Formatting Objects

Previewing and Printing Charts

Changing Chart Print Options

Setting General Chart Options

Creating Column or Bar Charts

Changing the Numbering Scale

Changing the Chart Series to Rows or Columns

Adding a Trendline to a Chart

Adding More Data to a Chart

Creating Basic Macros

Using Conditional Formatting

Creating Basic Macros

Creating a Custom Toolbar

Filling in a Series

Using the Fill Handle to Copy

Using the Fill Handle to Insert Dates

Filling a Number Series by Example

Using the Built-in Custom Lists

Creating New Custom Lists