Macro to ignore #N/A error for charting

Hello Everyone.. I've managed to create a macro that will select a range of cells & create a chart. The chart's a bit wonky, but that doesn't matter for now. As excel needs to have #N/A in a cell, rather than "" for it to be able to create a chart, I need find a way of making the selection process ignore the errors in the cells under the lowest cell with data in it. When the chart is created as it is now, it has spaces where the #N/A error is at the end of the chart. If those bottom error cells were ignored & the data selected, the charts last bar would be at the end of the chart.
I've attached a sample file of what I'm trying to do
Any ideas please?
Thanks