Charting Data and Automating Tasks

Charting Data

Creating Pie Charts

Overview of Chart Tools

Modifying and 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

Updating the Source Data

Conditional Formatting and Creating Macros

Applying Conditional Formatting

Applying Preset Conditional Formatting Rules

Editing Conditional Formatting Rules

Applying Conditional Formatting to Rows

Creating Macros Using the Macro Recorder

Using Relative vs. Absolute References

Running Macros

Editing Macros

Deleting Macros

Adding Macro Buttons to the Quick Access 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

Appendix: Working with Sparklines

Understanding Sparklines

Creating Sparklines

Showing Points and Markers

Applying Sparkline Styles

Changing the Type of Sparkline

Modifying Axis Options

Clearing Sparklines