I have a table of items and counts in range (A1:B5) thus:

Item1 0
Item2 1
Item3 2
Item4 0
Item5 1

I would like to create a pie chart but exclude the items that are 0 so as not to clutter up the chart. Is there a way to do this?

The numbers that appear are dynamic so the chart needs to be based on the entire range. i.e. I don't want just to use the ctl key to just select the items that are not zero at the time.

Thanks

Ben