+ Reply to Thread
Results 1 to 7 of 7

Automatically Update Table from Pivot Table

  1. #1
    Forum Contributor
    Join Date
    11-03-2014
    Location
    Belgrade
    MS-Off Ver
    2010
    Posts
    348

    Automatically Update Table from Pivot Table

    I'm not sure if I on the right board, but this is my question. Is it possible to create macro or some function to automatically update ordinary Table from Pivot Table. You can see in example that I have Pivot table (in "Report" sheet is data for it), and below Pivot Table I have the same one but normally table.
    Therefore, next month when I include the data for November, Pivot table can be refreshed on the click, but is there any way to Refresh the table below Pivot automatically?

    My Chart is depended on Second Table. Any options to include new data from second Table in Chart automatically?
    Please, just don't say: COPY/PASTE :D

    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Contributor Obsessed's Avatar
    Join Date
    05-22-2013
    Location
    Cincinnati, Ohio
    MS-Off Ver
    Excel 365
    Posts
    215

    Re: Automatically Update Table from Pivot Table

    Why not just use a pivot chart? Or even, a regular chart off the pivot table data source? Either of those are better options...you're trying to take data, pivot off of it, get back to the pivot data, to chart off of.
    Last edited by Obsessed; 11-06-2015 at 11:17 AM.
    Want to show appreciation for the help you received from a member? Give them reps by clicking the bottom left of their post!

  3. #3
    Forum Contributor Obsessed's Avatar
    Join Date
    05-22-2013
    Location
    Cincinnati, Ohio
    MS-Off Ver
    Excel 365
    Posts
    215

    Re: Automatically Update Table from Pivot Table

    Here you go. Pivot Table and Pivot Chart that I made (in orange) duplicates what you need...no need for your pivot table or your chart or your duplication table.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    11-03-2014
    Location
    Belgrade
    MS-Off Ver
    2010
    Posts
    348

    Re: Automatically Update Table from Pivot Table

    OK. Once more question. As you can see below my second table (Range A31) I got formula and that row I need to include in Chart also. How to connect it with Pivot Table or Pivot Chart?

  5. #5
    Forum Contributor
    Join Date
    11-03-2014
    Location
    Belgrade
    MS-Off Ver
    2010
    Posts
    348

    Re: Automatically Update Table from Pivot Table

    So, is there any solution for formula out of the Pivot Table?

  6. #6
    Forum Contributor Obsessed's Avatar
    Join Date
    05-22-2013
    Location
    Cincinnati, Ohio
    MS-Off Ver
    Excel 365
    Posts
    215

    Re: Automatically Update Table from Pivot Table

    Is it always a percentage of that one item? What is the purpose of it being in the chart...being formatted as a percent it will probably never register a bar on the chart.

  7. #7
    Forum Contributor
    Join Date
    11-03-2014
    Location
    Belgrade
    MS-Off Ver
    2010
    Posts
    348

    Re: Automatically Update Table from Pivot Table

    No. I will get some code like NCCC between those numbers (it's no problem to put it on the bottom), and I need do divide that cell with Total of that month.
    Today, I have 11 Class in Pivot table - Column A, but next I will have 15, maybe.

+ 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. Replies: 6
    Last Post: 02-23-2024, 02:11 PM
  2. [SOLVED] Pivot table doesn't update from external csv while data table does
    By Nick_Berlin in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 11-30-2014, 06:50 PM
  3. Replies: 3
    Last Post: 03-28-2014, 12:04 PM
  4. Replies: 0
    Last Post: 03-17-2014, 08:41 AM
  5. How to Automatically Update New Data within a Filtered Pivot Table?
    By templeoftyler in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-24-2013, 11:54 AM
  6. Update Pivot Table labels automatically
    By mtichbon in forum Excel General
    Replies: 0
    Last Post: 11-03-2011, 08:27 AM
  7. [SOLVED] Pivot Table update automatically?
    By shital shah in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2005, 06:06 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