I have a table that lists all the salesmen in one region. However, not all of the salesmen have entered orders this year. On a separate tab, I have a horizontal bar chart that displays the average number of days that it takes each salesman to submit an order. Currently, the chart is showing the salesmen that have not entered orders yet - they could enter orders next month, so I don't want to remove them from the spreadsheet completely. Is there a way to set the chart up to automatically display only the records in the table that show an actual number (instead of NA). That way, even though a salesman did not enter an order in February, if he enters an order in March he will appear on the chart. Is that possible?