Charting: How to Ignore Data points With Errors

Hi this is my situation:

i have a line chart which contains a scroll-down control to choose which data series i want (out of 12 series). however, the first few data points of these series contains errors due to non-real numbers.

eg: series a has first 3 data points with error
series b has first 5 data pts with error

is there any way i can set a formula to only plot data points without the errors (meaning after the last error cell onwards). having difficulty since this means all the series will have different starting points. thanks!

Have you tried handling the underlying errors such that all formula errors are converted to a #DIV/0! error - which do not plot

Please Login or Register  to view this content.