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
Dear smumin160 ,
I am glad that you like it!
Download the rest too, there are many other great notes and stuff in some of the other workbooks!
--excelisfun
ExcelIsFun 2 years ago
This workbook 285-294 is absolutely fantastic!!!!!
smumin160 2 years ago