| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I prevent blank cells from charting?
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? |
|
#2
|
|||
|
|||
|
How can I prevent blank cells from charting?
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/P...cle.asp?ID=390 Cheers Andy Teri wrote: 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, Microsoft MVP - Excel http://www.andypope.info |
|
#3
|
|||
|
|||
|
How can I prevent blank cells from charting?
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" wrote: 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/P...cle.asp?ID=390 Cheers Andy Teri wrote: 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, Microsoft MVP - Excel http://www.andypope.info |
|
#4
|
|||
|
|||
|
How can I prevent blank cells from charting?
Hi Teri,
I have updated the example workbook to include revised formula for handling data in rows as well as columns. Cheers Andy Teri wrote: 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" wrote: 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/P...cle.asp?ID=390 Cheers Andy Teri wrote: 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, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#5
|
|||
|
|||
|
How can I prevent blank cells from charting?
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 :) "Andy Pope" wrote: Hi Teri, I have updated the example workbook to include revised formula for handling data in rows as well as columns. Cheers Andy Teri wrote: 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" wrote: 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/P...cle.asp?ID=390 Cheers Andy Teri wrote: 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, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting Blank Cells Wholesale? | Excel Discussion (Misc queries) | |||
| Blank cells represented in area charts | Charts and Charting in Excel | |||
| Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
| Charting of Merged Cells | Excel Discussion (Misc queries) | |||
| blank cells | Excel Discussion (Misc queries) | |||
Linear Mode
