Programming Excel with VBA and .NET

Chart Objects

You use the Chart objects to display data graphically. Excel charts may exist on their own sheets or be embedded on a worksheet, so you can get at Excel charts through the Charts collection (for chart sheets) or the ChartObjects collection (for embedded charts), as shown in Figure 4-16. This part of the Excel object library is many levels deep, because it provides control over every graphic object on a chart...right down to the individual points in a series.

Figure 4-14. Objects for working with workbook files

Figure 4-15. Objects for working with worksheets and ranges of cells

Figure 4-16. Objects for charting and formatting charts