If you have Excel 2003
Put text on the cells at the top of the labels column and the number column
Select the range that includes both columns
Use Data|List|Create List
Click the label at the top of the number column: select Non-blanks
The chart not shows only rows with data
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Emile" wrote in message
...
I have a column with 55 rows. If there is a value in any cell I want to
take those values (never more than 10) and create a pie chart. The
description for each piece of the pie would come from a cell three columns
to the left in the row that has a value.

The chart has a legend.

Can I automatically create a chart with only the number of pies that
represent the cells that have a value and automatically generate the
correct legend?

The way I am doing it now if only 2 cells have values, I get a chart the
two values plus 8 with 0 values and still 10 entries in the legend.

Any suggestions

Thanks in advance for your help.