Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011

    Unanswered: A "Blank" value?

    Howdy,

    I'm routinely plotting data that includes random empty cells. I'd like the graph to skip the blank cells - not to plot zero and not to break the plot line.

    I see an option under "Options - Charts" to interpolate empty cells, but the whole set of options for for empty cells is disabled.

    Any ideas?

    tc
    have fun!

    Todd S.
    click to email


    Independent Development Consultant
    Biz db & reports - SQL, Access, Crystal, Seradex and more
    Small, custom, unique programs - Office, VBA, .NET


    _________________________________________________
    Favorite message from Windows:
    There was an error displaying the previous error message

    Sadly, there was no error number to look up ...

  2. #2
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    ok, so I got the options to come alive. They don't fix the problem, which is the graph treating the blanks as zeros.

    Any ideas on how to get a graph to skip blank values?

  3. #3
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011

    solution

    Found the answer:

    NA() which returns #N/A in the cell which is ignored by he graph.
    have fun!

    Todd S.
    click to email


    Independent Development Consultant
    Biz db & reports - SQL, Access, Crystal, Seradex and more
    Small, custom, unique programs - Office, VBA, .NET


    _________________________________________________
    Favorite message from Windows:
    There was an error displaying the previous error message

    Sadly, there was no error number to look up ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •