Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

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

Loading...

Sign in or sign up now!
5,504
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Mar 16, 2009

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

  • likes, 1 dislikes

Link to this comment:

Share to:
see all

All Comments (1)

Sign In or Sign Up now to post a comment!
  • 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

  • This workbook 285-294 is absolutely fantastic!!!!!

Loading...

0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more