Working with Charts


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 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 more than 100 different chart types, and you have a great deal of control over nearly every aspect of each chart.

0 0

Post a comment