How can I prevent blank cells from charting?

[Teri]

I've written my formulas so that a zero value will show as blank. I do not
want this to chart in my pie-chart. How can I make this happen?

 

[Andy Pope]

Hi,

Do remove zero values see this example.
http://andypope.info/charts/piezeros.htm

Read this article which includes tips on how to avoid unwanted data labels.
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=390

Cheers
Andy

 

[Teri]

Andy, I did see this example and it works beautifully in the example.
However, my data is in a ROW, not in columns. I'm not sure I have the
expertise to convert unless I create a whole other table and have my row
populate it. Your suggestion?

 

[Andy Pope]

Hi Teri,

I have updated the example workbook to include revised formula for
handling data in rows as well as columns.

Cheers
Andy

 

[Teri]

Well, aren't you wonderful? I'll check it out; am sure it will be PERFECT!
Thanks so much for your time and helpful consideration