Create Chart using VBA and Ignoring Rows with #N/A

[sndameron]

Below is a sample of data. First column is the x-axis, second is the y -axis. I need to create a scatter plot of the below data in vba. I do not want it to plot the row with the #N/A in but rather have it just ignore that row and continue plotting the rest of the data. Filtering the data is not possible.

Much appreciated!

2	1
8	2
22	3
40	4
#N/A	5
5	6
25	7
13	8
25	9
1	10

<!--StartFragment--> <colgroup><col width="65" span="2" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>

 

[Andrew Poulsom]

If I plot all your data I only get 9 points on an XY(Scatter) Chart. In other words the #N/A is ignored automatically.

 

[sndameron]

I know it it appears that it doesn't plot that point but the problem is that I'm running another script after this that shades everything to the left of the curve and the problem is when it does that because that cell is part of the series the script sees that #na as a zero. So the easiest solution is to get a script to create the series but omit any #na

If I plot all your data I only get 9 points on an XY(Scatter) Chart. In other words the #N/A is ignored automatically.

 

[Andrew Poulsom]

What's your macro that shades?