Chapter 12. Creating Charts and PivotTables

An Introduction to Charts

One of the main components of Excel is its ability to take the numerical data in your worksheet and create a chart.

Charts help to visually show the data in meaningful ways that you may not see clearly when viewing only numbers. For example, charting data as a line chart can help you to spot trends, while charting data as a pie chart helps you to see which product is a bestseller in relation to others in a set of data.

Types of Charts

Excel provides many types of charts to choose from, and one of the main decisions when creating a chart is selecting a chart that best conveys the message you want. The following table describes the most common chart types.

Type of Chart


Description ...

Get Master Visually®: Microsoft® Office 2007 now with O’Reilly online learning.

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