Chapter 14. Working with Charts, PivotTables, and Sparklines

Although Excel is an excellent tool for tracking and calculating data, there are times when you might want to summarize this data or display it in a more visual way. Fortunately, Excel offers several easy options to accomplish this.

Creating a chart is an effective way to illustrate the data in your worksheet. It can make relationships between numbers easier to see because it turns numbers into shapes, and the shapes can then be compared to one another. If your worksheet contains data you want to summarize, consider creating a PivotTable report. A final option is to create a mini chart called a sparkline in a cell adjacent to your data.

Get Easy Office 2013 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.