+ Reply to Thread
Results 1 to 3 of 3

Dynamic chart not working once moved.

  1. #1
    Registered User
    Join Date
    07-05-2011
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    7

    Dynamic chart not working once moved.

    Hi, I've got this really good (in my eyes) dynamic timeline chart, however it stops working properly when moved or copied to another workbook. I managed to get the dates changing via named ranges in the chart data however I can't get the labels to change. Any ideas as to what I'm missing. File is attached.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    08-12-2020
    Location
    Atlanta, Georgia
    MS-Off Ver
    Office 16
    Posts
    241

    Re: Dynamic chart not working once moved.

    When I open it, it is correct. When I copy it to another workbook my "Links" Icon lights up which means it is still linked to the original document. That is the issue. Somewhere on the moved copy is a formula, named range, or a control box that is pointing to the original document. That can cause a worksheet to fail because it cannot access the original formulas. Sometimes breaking these links works, sometimes not. When checking the link it is tied to the original document called project-timeline-template 201806.xlsx. I have not been able to locate where this is tied to on the copy document.
    There are excel add-ins that can help you locate these external links. My current computer does not have that. I will keep looking.
    Last edited by Squeaky; 10-13-2020 at 11:43 AM.

  3. #3
    Forum Contributor
    Join Date
    08-12-2020
    Location
    Atlanta, Georgia
    MS-Off Ver
    Office 16
    Posts
    241

    Re: Dynamic chart not working once moved.

    Hi Daren,
    This is what I found. Click on a Step in the chart so the SERIES formula displays in the formula Bar. I see: =SERIES(pmdash!$L$24,'project-timeline-template 201806.xlsx'!DATE_CONTROL,'project-timeline-template 201806.xlsx'!Position,1)
    Then do the same in the other spreadsheet this was copied to. The SERIES formula is not the same. If you copy the formula from the working sheet to the new sheet, and put the workbook name in place of 'project-timeline-template 201806.xlsx' (both places) leaving the ' ' in place, and make sure .xlsx is at the end, it will start working. Instead of exporting the sheet to another workbook, you may want to save as, and move the other sheets into that unless someone can suggest how to get around this.

+ 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. Dynamic Chart Range working but chart not updating
    By jp16 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-20-2020, 03:31 AM
  2. Dynamic chart stops working after its saved and re-opened
    By Stew7 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-25-2017, 03:27 AM
  3. Hyperlinks not working when the spreadsheet is moved
    By Uni2023 in forum Excel General
    Replies: 1
    Last Post: 10-18-2013, 03:00 AM
  4. Dynamic chart with Offset not working? Volitale??
    By trillium in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 05-13-2013, 12:16 PM
  5. Dynamic chart not working with stacked column
    By simonzxr in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-27-2012, 08:09 AM
  6. [SOLVED] Dynamic XY Chart no working
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2006, 07:00 PM
  7. [SOLVED] Scroller Incrementation:dynamic chart working,
    By unique in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-04-2005, 11:20 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