Chapter 18: Working with Charts

 Download CD Content

Overview

In This Chapter

Excel's charting feature lets you create a wide variety of charts using data that's stored in a worksheet. In this chapter, I discuss the following:

• Essential background information on Excel charts

• The difference between embedded charts and chart sheets

• Understanding the Chart object model

• Using methods other than the macro recorder to help you learn about Chart objects

• Examples of common charting tasks that use VBA

• Examples of more complex charting macros

• Some interesting (and useful) chart-making tricks

Excel supports a wide variety of chart types, and you have a great deal of control over nearly every aspect of each chart. In Excel 2007, charts look better than ever.