Chapter 16. Charting
Excel is perhaps the preeminent business tool for charting data. It’s hard to find a business presentation, technical report, or even a school science project that doesn’t chart data, usually through Excel.
In fact, charting is so important that I devote two chapters to it. This chapter covers the primary tasks: how to create different types of charts in code and how to control the main parts of a chart. The following chapter covers the secondary charting tasks.
This chapter includes task-oriented reference information for the following objects and their related collections: Axis, Chart, ChartGroup, ChartObject, DataTable, Point, Series, and SeriesLines.
Tip
Code used in this chapter and additional samples are available in ch16.xls.
Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
