Conditional Charts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Emile - 27 Apr 2007 17:13 GMT

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.

Reply to this Message

Bernard Liengme - 28 Apr 2007 13:55 GMT

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

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>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
[quoted text clipped - 13 lines]
>
> Thanks in advance for your help.

Reply to this Message

John Mansfield - 29 Apr 2007 18:12 GMT

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

Signature

John Mansfield
http://cellmatrix.net

> 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
[quoted text clipped - 13 lines]
>
> Thanks in advance for your help.

Reply to this Message