This article is an excerpt from Excel 2007 VBA: Programmer's Reference by John Green, Stephen Bullen, Rob Bovey, and Michael Alexander. Visit Wrox.com to learn more about this book.

You can use the macro recorder to discover what objects, methods, and properties are required to manipulate charts. You can then improve and extend that code to make it more flexible and efficient. The SetSourceData method of the Chart object is the quickest way to define a completely new set of data for a chart. You can also manipulate individual series using the Series object, which is a member of the chart’s SeriesCollection object.