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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.