+ Reply to Thread
Results 1 to 1 of 1

Update chart data with VBA

  1. #1
    Registered User
    Join Date
    09-12-2012
    Location
    gemestio are
    MS-Off Ver
    Excel 2010
    Posts
    53

    Update chart data with VBA

    Hi guys,

    I have the following problem (please see the attached file) - i have built a 3-D chart from a source data containing entries for the last 4 quarters by program. For the new quarter, I want to insert a new column into the table and have the chart automatically capture the 4 most recent quarters. Is there a way to set the source data reference in VBA so that it does not change (i.e., always captures data from the same columns based on their names - columns A:E in my example)?
    Ideally, this will happen when the chart worksheet gets activated.


    Thanks a lot!!

    D.
    Attached Files Attached Files

+ 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. Chart not updated until chart sheet opened following source data update
    By untilyesterday in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-24-2013, 12:27 PM
  2. Charting file template to clear old data, paste new data and update chart
    By cwilliams321 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-29-2012, 04:13 PM
  3. [SOLVED] Update a chart immediately after inputting data into data source
    By MELMEL in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-01-2005, 05:40 PM
  4. can my chart update itself if i add data?
    By caldolegare in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-29-2005, 11:05 PM
  5. [SOLVED] Update Chart data Range with VBA
    By Roger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2005, 10: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