Results 1 to 2 of 2

Checking if a data point exists on a chart

Threaded View

  1. #1
    Registered User
    Join Date
    09-15-2005
    Posts
    24

    Checking if a data point exists on a chart

    Hi all,

    I have a set of data points that I add custom labels to using a macro. Problem is that if oine of the points is in the spreadsheet as #n/a, then it does not get ploted so my macro which sequentially runs through each point fails.

    Is there anyway to check to see if a particular data point exists for a given series?

    Thanks in advance!
    Last edited by VBA Noob; 07-11-2008 at 01:04 PM.
    Science is a lot like ***: Sometimes something useful comes out, but that is not the reason we are doing it. - Richard Feynman

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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