Results 1 to 3 of 3

Pivot Chart Filter

Threaded View

qiyusi Pivot Chart Filter 09-30-2016, 10:06 PM
peterrc Re: Pivot Chart Filter 10-01-2016, 06:04 AM
qiyusi Re: Pivot Chart Filter 10-03-2016, 07:38 AM
  1. #1
    Forum Contributor
    Join Date
    10-22-2014
    Location
    Indonesia
    MS-Off Ver
    2010
    Posts
    177

    Pivot Chart Filter

    Hello,

    I am not routinely work with pivot table.

    Would be appreciate if someone can give me advise about what i am trying to do.

    On attached file,

    I have a pivot chart with year on year data by monthly, for one product.

    what i want, how to set the filter , so the pivot chart will automatically change the product,
    current chart is Sum of apple, what i need, when i click sum of apple, i can choose sum of banana or sum of mango, then the chart will change the data.

    maybe you can have better understanding if you review the sheet.

    Thank you in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Problem with field and filter in pivot chart
    By noobforce123 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-25-2015, 02:11 AM
  2. Pivot Chart not updating when Pivot filter changes
    By kmac153 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-30-2014, 02:45 AM
  3. Syncronizing two report filter in Pivot Chart
    By pankaj2610 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-30-2014, 08:03 AM
  4. Help filter out zeros from pivot chart
    By karlulfeinar in forum Excel General
    Replies: 3
    Last Post: 06-08-2011, 08:10 AM
  5. Pivot chart - can I label filter and Top 10
    By MorganW in forum Excel General
    Replies: 1
    Last Post: 05-10-2011, 01:50 AM
  6. VBA/Macro to apply a filter to a pivot chart
    By ianh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-01-2011, 06:04 AM
  7. Pivot Chart filter
    By jmccullough in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-02-2009, 10:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1