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


--
blatham
------------------------------------------------------------------------
blatham's Profile: http://www.excelforum.com/member.php...o&userid=19441
View this thread: http://www.excelforum.com/showthread...hreadid=567907