+ Reply to Thread
Results 1 to 2 of 2

Auto update Pivot Chart

  1. #1
    Registered User
    Join Date
    11-17-2014
    Location
    Sydney
    MS-Off Ver
    2013
    Posts
    8

    Auto update Pivot Chart

    Hi,

    Apologies if this has been answered but my searches don't seem to resolve my question.

    I have created a Dashboard that I want to use as a template.

    Daily transaction data will be appended to the data tab and I want to make sure that the pivot table and chart update automatically. Is there a way to do this?

    See attached file.

    Thanks
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-11-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    86

    Re: Auto update Pivot Chart

    Create a named range by using the below formula then pass the name as the data source of all the pivots, then create the charts from the updated piovt tables. use the below code in any of the event of your choice to refresh the all the pivot Tables.

    =OFFSET('Sheetname'!$A$1,0,0,COUNTA('Sheetname'!$A:$A),COUNTA('Sheetname'!$A$1:$IV$1))


    Dim ws As Worksheet
    Dim pivot As PivotTable
    'Dim z As PivotCache
    For Each ws In oWB_Data_File.Worksheets
    If ws.PivotTables.Count > 0 Then
    For Each pivot In ws.PivotTables
    pivot.RefreshTable
    Next pivot
    End If
    Next

+ 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. Auto Update Chart
    By weeeee0713 in forum Excel General
    Replies: 5
    Last Post: 09-29-2014, 01:43 AM
  2. chart auto update
    By willexcel in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-27-2014, 01:51 PM
  3. Auto Update Pivot Chart
    By tazcorp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-16-2013, 05:28 PM
  4. Chart Auto Update
    By Reyan123 in forum Excel General
    Replies: 1
    Last Post: 07-19-2007, 08:48 AM
  5. [SOLVED] auto update of a chart
    By TUNGANA KURMA RAJU in forum Excel General
    Replies: 1
    Last Post: 06-24-2006, 05:00 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