15. Creating Charts

Charting in Excel 2013

Charting gets a major makeover in Excel 2013, and this creates a host of new charting methods and properties in Excel 2013 VBA.

The process of creating a chart introduces a streamlined .AddChart2 method. With this method, you can specify a chart style, a chart type, and a new property: NewLayout:=True. When you choose NewLayout, you will finally avoid a legend for single-series charts.

After you select a chart, three icons appear to the right of the chart. ...

Get Excel® 2013 VBA and Macros 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.