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
Bookmarks