Creating a chart in Excel that ignores N A or blank cells

Question

A dynamic data series will be used in the chart I'm trying to make. Each string in the graph is based on an absolute range, although only a portion of that range may have data, with the remainder being #N/A.

The chart's #N/A cells should all be ignored; instead, they are all assigned values, which is an issue. I've found a way to get around that by utilizing named dynamic ranges, however, that is incredibly inefficient because each chart has four dynamic series, and I need to create 25 of these charts.
Any other options that let me set a range for a data series as per usual while instructing the chart to ignore all "#N/A" or blank cells?