Excel Charts
 

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

Excel Charts
 

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

"Dave" wrote:

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