Excel Forum
Similar Content
Create and Manage Tables in Excel
Tutorial: Here, I'll show you everything you need to know to get started using tables in Excel; how...
Display Filter Arrows in a Table or Data Set in Excel - AutoFilter
Macro: This free Excel macro allows you to apply filter settings to a data set, list, or range of...
Create Gantt Chart in Excel Easily
Tutorial: Easy step-by-step guide to creating a Gantt Chart in Excel. Following these steps, it sh...



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.