Removing #N/A from the X Axis of any chart Automatically

I have a table with #N/A values. The #N/A values must be in the range selection for the chart (below the table). I cannot rely on filtering for my project. The #N/A and associated column space shows up in the chart. It needs to go away so only customers with real values are shown.

Please help.

Thank you kindly,