Pivot Table Data Crunching for Microsoft® Office Excel® 2007

Chapter 6. Using Pivot Charts and Other Visualizations

<feature><title>In This Chapter</title>

• What Is a Pivot Chart...Really? 141

• Creating Your First Pivot Chart 142

• Keeping Pivot Chart Rules in Mind 145

• Case Study: Creating a Report Showing Invoice Frequency and Revenue Distribution by Product 148

• Examining Alternatives to Using Pivot Charts 153

• Using Conditional Formatting with Pivot Tables 157

• Next Steps 166

</feature>

What Is a Pivot Chart...Really?

When sharing your analyses with others, you will quickly find that there is no getting around the fact that people want charts. Pivot tables are nice, but they leave lots of those pesky numbers that take time to absorb. Charts, on the other hand, enable users to make a split-second determination on what ...