Results 1 to 3 of 3

Chart Data not updating when macro adds new line to data range for chart

Threaded View

ig254 Chart Data not updating when... 10-15-2014, 08:21 PM
noboffinme Re: Chart Data not updating... 10-16-2014, 03:43 AM
ig254 Re: Chart Data not updating... 10-16-2014, 08:57 PM
  1. #1
    Registered User
    Join Date
    06-01-2014
    Posts
    3

    Chart Data not updating when macro adds new line to data range for chart

    I have a rainfall chart that has two columns of data A2 with Date and B2 with rainfall. I run a macro that copies the previous row A2 & B2 and inserts it above the previous row . The new row becomes 2 and the date is update to next day in A2 and B2 is cleared of previous data. This data in A2 to b2300 is added to a simple line chart but the data does not update after macro is run.
    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Updating Line Chart with Named Range
    By bruno08102013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-18-2014, 09:48 PM
  2. [SOLVED]Line Chart from dynamic range of data
    By jason.holtzen in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-17-2014, 10:50 AM
  3. Updating Chart Series Data with a macro
    By sherry_1991 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2012, 01:39 PM
  4. Replies: 6
    Last Post: 07-27-2012, 06:24 AM
  5. automaticaly updating chart when adds a new data
    By Dao4free in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-24-2008, 10:56 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