+ Reply to Thread
Results 1 to 7 of 7

Pivot Chart Filters

  1. #1
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Crayford, kent
    MS-Off Ver
    Excel 2013
    Posts
    394

    Pivot Chart Filters

    Can anyone help or explain if this is possible please???

    I have a chart which is generated by a pivot, in the chart are the fields which you can drop down and select what you want to view.

    For example, Jan, Feb, Mar, Apr, May, etc.

    But..... however clever this is and preferable for me, when i print the sheet the chart just shows a field button with period in it. Is there a way i can get the chart to display the periods chosen, rather than having them in the axis of the chart?

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Pivot Chart Filters

    How about using a slicer, linked to the month field? It will give a visual indication of which data values are included / excluded.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Crayford, kent
    MS-Off Ver
    Excel 2013
    Posts
    394

    Re: Pivot Chart Filters

    Unfortunately I'm running off 2007, these are only available in 2010 aren't they?

  4. #4
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Pivot Chart Filters

    Quote Originally Posted by shiftyspina View Post
    Unfortunately I'm running off 2007, these are only available in 2010 aren't they?
    Yes - I gave my answer based on the version you display on your profile!

    shifty2010.jpg
    Last edited by Olly; 10-16-2013 at 10:41 AM.

  5. #5
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Crayford, kent
    MS-Off Ver
    Excel 2013
    Posts
    394

    Re: Pivot Chart Filters

    I do use 2010 usually, but the sheet i created this in an the computer im running off at the mo is in 2007, i can transfer it across and hopefully use the slicer, im guessing its easier than trying to do it in excel 2007

  6. #6
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Crayford, kent
    MS-Off Ver
    Excel 2013
    Posts
    394

    Re: Pivot Chart Filters

    I have sussed, it i opened up my file in excel 2010 and found where the slicers are, so i understand how to do it now, and its exactly what i needed, thank you for your help.

  7. #7
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Pivot Chart Filters

    Excellent, glad it worked for you! Slicers are a nice neat solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Value filters removed on Pivot
    By Kyle123 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-06-2013, 04:16 AM
  2. Pivot Filters through VBA
    By JimmyA in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-23-2013, 11:29 AM
  3. Marco for changing numerous pivot chart filters at once
    By Nick Simo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2012, 12:09 PM
  4. Excel 2007 : Pivot tables filters
    By Squevil in forum Excel General
    Replies: 1
    Last Post: 11-04-2011, 10:30 AM
  5. [SOLVED] pivot chart filters
    By maryj in forum Excel General
    Replies: 2
    Last Post: 06-14-2006, 08:00 AM

Tags for this Thread

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