Your original example had a gap between the block of data and a final row. I assumed this final row was what you meant when saying, "If those bottom error cells were ignored".
Does using autofilter and not showing hidden cells give you the chart you are after?
Bookmarks