Excel Charts

[Dave]

Hi

I have to columns of data, one with product types and the other with the
amount which have been sold during the month.

I would like to show this data as a pie chart however if I have not sold one
of a product it still appears in the pie chart. How do I stop products with
zero appeaing in the pie chart?

Thanks

 

[Eduardo]

Hi,
before inserting the chart, sort the sold column, uncheck what shows as
blank then insert the chart