+ Reply to Thread
Results 1 to 2 of 2

Dynamic Chart works but keeps giving errors when my page is empty, frustrating to fill out

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    11-11-2004
    MS-Off Ver
    pro + 2019
    Posts
    134

    Dynamic Chart works but keeps giving errors when my page is empty, frustrating to fill out

    I built a successful dynamic chart--simple with categories and expenses.

    If I clear out all the test items I've been using i keep getting an error (with the beep and dialogue box) like this:

    "excel found a problem with one or more formula references in this worksheet. check that the cell reference, range names, defined names, and links to other workbooks in your formulas are all correct."

    If I keep at least one line filled it's fine--and I can work around to never have a blank screen.

    Is this something that comes with dynamic charts? That because it's always re-defining the table ranges it doesn't like to see...."nothing"?


    thanks guys,
    as always.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,741

    Re: Dynamic Chart works but keeps giving errors when my page is empty, frustrating to fill

    I suspect that it may be that, when you calculate the row, you end up with a zero. So, for example, you may be referring to, say, cell A0 ... which doesn't exist.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. PIe chart based on dynamic range - Error when empty
    By rousseauassociates in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-11-2015, 08:42 AM
  2. [SOLVED] Colour fill of empty cells in a dynamic range
    By Coems in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-19-2014, 06:27 PM
  3. How to stop plotting empty cells in a dynamic area chart
    By latha2002 in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 12-20-2012, 03:46 AM
  4. VBA keeps giving errors on PasteSpecial
    By Inter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-11-2012, 11:45 PM
  5. Dynamic Chart will not work as empty cells contain Formulas
    By feno1 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-11-2011, 03:22 AM
  6. Simple but frustrating problem with chart
    By geigerc0unter in forum Excel General
    Replies: 3
    Last Post: 06-02-2007, 04:27 PM
  7. Replies: 0
    Last Post: 02-01-2006, 12:45 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