Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
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.