Excel 2002 Charts & Lists

The following topics are covered:


Excel Charts:

Creating a Chart with the Wizard, Resizing and Moving Chart Objects, Changing Chart Type, Charting Non-Adjacent Data, Adjusting Scale, Two-Scaled Charts

Adding, Removing and Formatting: Legend, Gridlines Data Series

Adding Explanatory Text, Callouts, Arrows & Circles, Data Labels, Setting the Default Chart

Creating a Graph with one Keystroke, Adding Custom Chart Types to the List, Changing Chart Location (Chart Object vs. Chart Sheet), Adding a Projection to a Data Series

Excel Lists:

Creating a List: The Rules, Sorting a List, Custom Sort Orders, The Data Form

Filtering a List: AutoFilter & Advanced Filters

List Subtotals, Using the Outline, Creating & Modifying Pivot Tables