Excel Forum
Similar Content
Reuse Pivot Table Filters in Row, Column, & Value Fields
Tutorial: 2 ways to add Pivot Table Filter Fields (page fields) to row, column, and value fields wh...
Easy Pivot Table in Excel (Auto-Subtotals Feature)
Tutorial: How to make a paired-down version of a Pivot Table for Excel. This allows you to quickly ...
Hide Worksheets with Passwords in Excel (No Code Required)
Tutorial: Password protect and completely hide worksheets in Excel in order to protect sensitive da...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 294: Filter Pie Chart w Formula & Pivot Table


See how to filter a Pie Chart so that only the Account Manager's Sales Reprentatives show up in the Pie Chart Graph. See how to do this with:
1) Pivot Table and Report Filter (Page Filter)
2) Data Validation, VLOOKUP, ROWS, SUMPRODUCTS and SUMIFS functions in formula.

Great VLOOKUP trick for changing column reference when copying formula down across the rows





Got a Question? Ask it Here in the Forum.