How can I prevent blank cells from charting?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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, 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?
 
Hi Teri,

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

Cheers
Andy
 
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 :)
 
Back
Top