+ Reply to Thread
Results 1 to 5 of 5

Existing Dynamic Chart adding in new columns of data not updating when new rows are added

  1. #1
    Registered User
    Join Date
    05-17-2022
    Location
    Florida
    MS-Off Ver
    2016
    Posts
    3

    Existing Dynamic Chart adding in new columns of data not updating when new rows are added

    First post:

    I have an excel problem with dynamic charts we use weekly.

    Short of it is we have two charts showing a 12 week lookback and 49 week lookback.

    We add new row of data to each week and the charts show a lookback from the new week for the specified terms.

    It was requested to add/insert two columns of data (F & K) which was done successfully butů

    Now the charts are not updating as it used to when a new row of data is added, it just keeps the same chart periods before the new columns of data were added.

    Included the original sheet which works as expected, and the test revised sheet that no longer automatically updates the dynamic charts when a new row of data is added.

    I think I have all the offset periods in correctly for each series but the chart no longer has the series info.

    Any help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    176

    Re: Existing Dynamic Chart adding in new columns of data not updating when new rows are ad

    The chart series do not refer to the dynamically defined range names, in the new workbook. Whereas that was the case in the old workbook.

  3. #3
    Registered User
    Join Date
    05-17-2022
    Location
    Florida
    MS-Off Ver
    2016
    Posts
    3

    Re: Existing Dynamic Chart adding in new columns of data not updating when new rows are ad

    Thanks, I had tried that before and could not get it to hold the range names. Gave it a shot again and it seems to be holding them now, except for the offsets for Column F for both charts. It looks correct but its pulling data from the middle of the range vs at the end for some reason.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    176

    Re: Existing Dynamic Chart adding in new columns of data not updating when new rows are ad

    Range F2:F61 of the Main Data sheet are blank cells, screwing with the OFFSET calculation.

  5. #5
    Registered User
    Join Date
    05-17-2022
    Location
    Florida
    MS-Off Ver
    2016
    Posts
    3

    Re: Existing Dynamic Chart adding in new columns of data not updating when new rows are ad

    Ah! Thanks that seems to have done it. Thanks so much for your help.

+ 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. [SOLVED] Adding/Updating Data to an existing Power Query
    By LisaWilliams231 in forum Excel General
    Replies: 5
    Last Post: 05-03-2020, 12:41 PM
  2. Chart not updating when new data is added
    By Willows59 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-27-2016, 08:29 PM
  3. Replies: 2
    Last Post: 12-30-2015, 04:47 PM
  4. Dynamic Chart Data not Updating
    By MVictorH in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-15-2015, 03:23 AM
  5. Adding Rows to one sheet when Data is added to the first one
    By Phoebus in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-04-2014, 07:39 AM
  6. adding new months data to an existing chart
    By sarahbeecher in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-20-2013, 10:55 PM
  7. adding data over existing chart
    By Diesel13 in forum Excel General
    Replies: 1
    Last Post: 03-04-2010, 10:30 AM

Tags for this Thread

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