Charts and Graphs: Microsoft® Excel® 2010

8. Creating and Using Pivot Charts

IN THIS CHAPTER

Creating Your First Pivot Chart 265

New in Excel 2010 Pivot Tables 265

Deciding Which Comes First: The Table or the Chart 266

Rules for Preparing Underlying Pivot Data 266

Creating Your First Pivot Chart 267

Returning to a Pivot Table for Advanced Operations 271

Filtering a Pivot Table 273

Creating a Chart for Every Customer 275

Creating Your First Pivot Chart

Pivot tables are the most powerful feature in Excel. A pivot table allows you to summarize a million records of transactional data in Excel with a few mouse clicks. A pivot chart is an extension of the pivot table concept. While building a summary of your data using a pivot table, you can specify that the results be presented in a chart. ...