Excel Charts to not show items without data

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.

Thank you.

I've uploaded an example. The data on the left is a masterfile, and the list on the right is just feeding off that data and a chart is associated.

If there are 0 values in the list, I would like to not see them in the chart. Hope this makes sense.

Many thanks in advance.

Hi, is there a solution to this? just so I know.

Many thanks in advance.

Thank you, it must have come in whilst I had the post open which is why I didn't see it.

Thank you JeteMC for the solution.