15. Creating Charts

In This Chapter

Charting in Excel 2013

Understanding the Global Settings

Creating a Chart in Various Excel Versions

Customizing a Chart

Creating a Combo Chart

Creating Advanced Charts

Exporting a Chart as a Graphic

Creating Pivot Charts

Next Steps

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.

Start your free trial