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.

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.

As another option, perhaps this example might help. It shows shows how to
exclude zeros but should also work with blanks.

http://www.cellmatrix.net/index.php/...de_zero_values

--
John Mansfield
http://cellmatrix.net





"Emile" wrote:

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.