Chapter 14. Working with Charts, PivotTables, and Sparklines


Although Excel is an excellent tool for tracking and calculating data, at times 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 ...

Get Easy Office 2016 now with O’Reilly online learning.

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