VBA create chart with series but skip cells with #N/A and move to next, not ignore but skip

[sndameron]

All through vba, I need to be able to create a chart, add a series, and skip any cells with #N/A, not IGNORE them but just move to the next cell when plotting. Here is sample data:

Y-axis	Series 1 (x-axis)	Series 2 (x-axis)
45.370​	29.24​	4.699738903​
45.710​	37.79​	3.25732899​
45.782​	61.96​
46.208​	76.72​
46.564​	71.35​
46.744​	61.67​

<tbody> </tbody>

MUCH APPRECIATED!!!