Bar Chart Showing Errors / Empty Values

I see two possible ways to do this:

1) Filters. Assuming the source data is arranged so that autofilter can be applied to the source range (https://www.wikihow.com/Use-AutoFilter-in-MS-Excel ), you can create the chart exactly as you have now. Then, tell Excel to use autofilter on this range, click on the dropdown for one of the columns, and apply an appropriate filter that will show only the meaningful rows. Assuming your chart's hidden and empty cell setting is set to "not show", then the chart will follow the filter. Everytime new data comes in, refresh the filter to get the chart up to date.

2) Use dynamic named ranges to build a dynamic chart. https://chandoo.org/wp/dynamic-chart-data-series/ The tutorial uses COUNTA() (assuming that you are only needing this so the chart knows how many used rows there are) where you will need more of a COUNTIFS() (to determine how many of the used rows are meaningful).

Try those two approaches and see which one is more in line with how you want to interact with the spreadsheet.