23. Graphing Data Using Excel Charts

Excel 2016 introduces six new chart types, which are discussed at the end of this chapter. Before getting to the new charts, the chapter covers general techniques for creating graphs.

Starting in Excel 2013, the Recommended Charts feature analyzes your data and suggests charts that might look good. The rules behind the chart recommendations are surprisingly good. In most cases, you will create good-looking charts by going with one of the recommendations. Excel never suggests a 3D chart because those types of charts misrepresent the data.

After you have the chart, a paintbrush icon offers 10 to 15 ways to style the chart. Styles range from minimalist to intense. If you are a disciple of Professor Edward R. ...

Get Excel 2016 In Depth 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.