Excel 2007 For Dummies
Book image
Explore Book Buy On Amazon

Just as you can filter an Excel 2007 pivot table to display a subset of data, you also can use the PivotChart Filter pane to filter a pivot chart so that it shows just the information you want it to show.

When you graph the data in an pivot table using a typical chart type, such as column, bar, or line chart that uses both an x- and y-axis, the Row labels in the pivot table appear along the x- or category-axis at the bottom of the chart, and the Column labels in the pivot table become the data series that are delineated in the chart’s legend. The numbers in the Values field are represented on the y- or value-axis that goes up the left side of the chart.

You can use the drop-down lists in the PivotChart Filter Pane to filter the charted data like you do the values in the pivot table. As with the pivot table, remove the check mark from (Select All) or (All) option and then add a check mark to each of the fields you still want represented in the filtered pivot chart.

Click the following drop-down buttons in the PivotChart Filter Pane to filter a different part of the pivot chart:

  • Axis Fields (Categories) to filter the categories that are charted along the x-axis at the bottom of the chart.

  • Legend Fields (Series) to filter the data series shown in columns bars, or lines in the chart body and identified by the chart legend.

  • Report Filter to filter the values charted along the y-axis on the left side of the chart.

About This Article

This article is from the book:

About the book author:

Greg Harvey has authored tons of computer books, the most recent being Excel Workbook For Dummies and Roxio Easy Media Creator 8 For Dummies, and the most popular being Excel 2003 For Dummies and Excel 2003 All-In-One Desk Reference For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, Greg went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.
His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience: the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.
Greg received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion last May. Everyone is glad that Greg was finally able to get out of school before he retired.

This article can be found in the category: