Good afternoon

I have a table of data delivering staff performance stats and a bar chart
that charts the data. Oftern, a staff member maybe absent, meaning that
there is zero data for the individual on that day. Short of changing the
chart range everytime this occurs (there are a lot of staff members so daily)
is there anyway of instructing the chart to ignore any zero values, thus
leaving that staff member out of the chart for that day?

Many thanks