Hello,

I have 2 columns: Column 1 is customer name. Column 2 is sales for the
period.

If a customer had no sales for the period the sales column will either be
N/A# or zero. When I plot in a pie chart, I only want to show customers who
had sales for that period.

Is there a way to only plot those customers with sales without having to
change the range and sort every period?

Customer Sales
Cust1 $100
Cust2 0
Cust3 $50
Cust4 N/A

The pie chart data labels show the customer regardless of sales and if I
blank out the customer, the value data label still shows 0 or N/A.

thanx for any direction.

db