Hi,

I have an excel chart based on a list with COUNTIFS, which feeds off a large set of data.

The list has all the items available and invariably some have 0 value if they are not in the larger data set, but the point is that they could have data. I would like the chart to not show the items that have no data at all.

For example, a list with all fruit, but in the large data set only certain fruits are populated. I don't want the chart to show all the fruits with 0 value, only the ones with values.

Is this possible?

Many thanks in advance.