Reading a single value from a series

[Nick]

Hi,

In an Excel VBA subroutine, I need to read a single value at a time
from a data series and perform different actions depending on whether
this value is a number or the string "#N/A". I tried the following:

If ActiveChart.SeriesCollection(s).Values(t) <> "#N/A" Then
(do whatever)

but it doesn't work (it says "wrong number of arguments or invalid
property assignment"). I'm not an Excel expert, so I don't know
exactly how this works, and the MSDN documentation is of little help
in this case. Also, how do I differentiate between the x-values and
y-values of the series? The data is for an X-Y scatter plot, and I
want to compare the y-values only (I don't care about the x-values).

Many thanks!
-Nick

 

[Tom Ogilvy]

See John Walkenbach's page on programmatically working with a series:

http://j-walk.com/ss/excel/tips/tip83.htm
A Class Module to Manipulate a Chart SERIES

You should be able to use that as a base approach to do what you want.