+ Reply to Thread
Results 1 to 2 of 2

Dynamic chart of counted data extracted from pivot table

  1. #1
    Registered User
    Join Date
    08-10-2016
    Location
    Belgium
    MS-Off Ver
    2010
    Posts
    3

    Dynamic chart of counted data extracted from pivot table

    Hello,

    In the screenshot attached you will see an overview of my problem (in the real file, every element is in a separate sheet).

    I need to create a chart that will update itself with the data added. I just learned about dynamic charts using the OFFSET function but I don't think it will do the trick because of the pivot table.

    The problem is that the pivot table (in blue) will expand along with the data added every month (in red). The green table was created by using COUNTIFS function with the needed columns in the pivot table (the numbers in the green table are wrong, it's just an illustration). So, of course, every time the data is updated, the columns in the pivot table are displaced and my references in the green table go wrong.

    How could I do it ?
    Do you think I could organize the pivot table differently, in a way that it won't mess up when data is added ?
    Or could I use the GetPivotData function (which I never quite understood) ?

    I am using Excel 2010. Hoping it's clear enough...
    Thank you very much !
    Test.PNG

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,410

    Re: Dynamic chart of counted data extracted from pivot table

    First of all, not everyone can see PNG files on this site. I am one of them. Secondly, it would help a lot if you could attach a sample workbook without sensitive data. You are correct that offset is the key to dynamic charting, but sometimes you have to get creative in how you calculate the arguments.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. How to set or change formats of the data extracted from Pivot table
    By divi123 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-09-2015, 08:40 AM
  2. How to set or change formats of the data extracted from Pivot table
    By divi123 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-06-2015, 02:12 AM
  3. Pivot Table (extracted data from pivot, in source formatting)
    By nsumitg in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 12-06-2013, 08:55 AM
  4. Replies: 0
    Last Post: 02-21-2013, 09:07 AM
  5. Replies: 4
    Last Post: 06-25-2012, 03:25 PM
  6. Replies: 5
    Last Post: 06-08-2012, 03:24 PM
  7. Dynamic Pivot Chart based on Pivot Table.
    By excelkeechak in forum Excel General
    Replies: 3
    Last Post: 12-01-2009, 09:23 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