+ Reply to Thread
Results 1 to 2 of 2

Auto update Pivot Chart

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Auto update Pivot Chart


    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.

    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    MS-Off Ver
    Excel 2007

    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.


    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
    Next pivot
    End If

+ 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


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