+ Reply to Thread
Results 1 to 3 of 3

Dynamic Chart - Invalid reference error message

  1. #1
    Registered User
    Join Date
    South Africa
    MS-Off Ver
    Excel 2010

    Dynamic Chart - Invalid reference error message


    I have created a dynamic chart and continously get an invalid reference message. I am assuming that this error message is triggered due to the dynamic chart.

    Please provide recommendations on how we can disable or prevent this popup message.


  2. #2
    Valued Forum Contributor adyteo's Avatar
    Join Date
    MS-Off Ver
    Excel 2010

    Re: Dynamic Chart - Invalid reference error message

    Anthony, could you please upload your working file? Please remove any confidential info.
    Click on the star if you think I helped you

  3. #3
    Forum Expert RobertMika's Avatar
    Join Date
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13

    Re: Dynamic Chart - Invalid reference error message

    Look at your Dynamic Ranges.
    I assume you have used OFFSET+COUNTA.
    Do they point to the right cell,do they have the right offset height/width?
    All references must have absolute cell ranges -so $ sign before letter and number
    example $A$1.
    A$1 or A1 could cause the problem
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Replies: 0
    Last Post: 03-10-2013, 11:17 PM
  2. Invalid Reference error
    By MasonGrey in forum Excel General
    Replies: 4
    Last Post: 12-27-2012, 06:29 PM
  3. Replies: 1
    Last Post: 04-30-2012, 12:07 PM
  4. Create an error message when retrieving information for invalid dates
    By Habanero Time in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-12-2012, 11:56 PM
  5. Replies: 1
    Last Post: 02-17-2006, 12:10 PM


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