Excel Forum



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.