Conditional Charts

[Emile]

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.

 

[Bernard Liengme]

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

 

[John Mansfield]

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/pie_chart_exclude_zero_values