Excel Charts

  • Thread starter Thread starter Dave
  • Start date Start date
D

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
 
Hi,
before inserting the chart, sort the sold column, uncheck what shows as
blank then insert the chart
 
Back
Top