JaB,

In math zero does not mean nothing, it means something, so it should be
plotted. I leave the cell empty when no data are reported. like in your case.
This is more accurate than using 0, and fixes your problem.

regards,

Gelbstoff

"JaB" wrote:

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