Microsoft Office Tutorials and References
In Depth Information
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, Ex-
cel 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.
Chart and PivotTable Tools