+ Reply to Thread
Results 1 to 5 of 5

(SOLVED) Pivot Table Chart - How to Display the item you are filtered on???

  1. #1
    Registered User
    Join Date
    03-06-2019
    Location
    Darlington
    MS-Off Ver
    2016
    Posts
    19

    (SOLVED) Pivot Table Chart - How to Display the item you are filtered on???

    Hi All,

    I wonder if anyone can help me.

    I have created a chart from a pivot table which is great as the chart will change to whatever I am filtered on, in my case sites spend month on month.

    the filter is called Site Name and when I click the drop down I can select site to show but I want to show the name of the site I am filtered on - is this possible?

    thanks in advance.
    Dan
    Attached Images Attached Images
    Last edited by tyke01; 03-06-2019 at 08:50 AM. Reason: SOLVED

  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 Table Chart - How to Display the item you are filtered on???

    You could reference the cell of the associated pivot table containing the filter value, in the chart title.

    Worked example: https://excel.solutions/pivotchart-filtered-title/
    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
    Registered User
    Join Date
    03-06-2019
    Location
    Darlington
    MS-Off Ver
    2016
    Posts
    19

    Re: Pivot Table Chart - How to Display the item you are filtered on???

    Thanks - This was a great help!

  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: (SOLVED) Pivot Table Chart - How to Display the item you are filtered on???

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You can also 'Add Reputation' to those who helped. Thanks.

  5. #5
    Registered User
    Join Date
    03-06-2019
    Location
    Darlington
    MS-Off Ver
    2016
    Posts
    19

    Re: (SOLVED) Pivot Table Chart - How to Display the item you are filtered on???

    Done and Done!

+ 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. Add a ROW with aggregated data to pivot table and display on a chart
    By pfraiegari82 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-13-2018, 04:01 AM
  2. Replies: 20
    Last Post: 08-20-2014, 02:21 PM
  3. Pivot Table to roll up data and display in pivot chart
    By Dawson64 in forum Excel General
    Replies: 3
    Last Post: 09-26-2011, 05:06 PM
  4. Why do Pivots display pivot item tick boxes that are not visible in the pivot?
    By davellll in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-27-2009, 12:53 PM
  5. Replies: 0
    Last Post: 03-22-2009, 07:17 PM
  6. [SOLVED] Pivot Table - display filtered data
    By Jeff M in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-16-2005, 01:05 PM
  7. [SOLVED] Display Pivot Table Chart in Powerpoint
    By wengyee in forum Excel General
    Replies: 1
    Last Post: 03-08-2005, 11:06 AM

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