Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pie Chart Tweaking?
I create a pie chart from a set of values (formulas), some of which may
compute as zero from time to time. Because the data range contains formulas (I guess), the cells aren't interpreted as zeros or empty cells. So, the pie chart may contain one or two 0 percent slices. (Actually, there's a title and a line drawn to one or more non-existent slices.) I would like to avoid such a picture, drawing only non-zero slices. Is there a way to do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pie Chart Tweaking?
Have a read of this article & see if it helps you.
http://pubs.logicalexpressions.com/P...cle.asp?ID=390 -- jb "John V" wrote: I create a pie chart from a set of values (formulas), some of which may compute as zero from time to time. Because the data range contains formulas (I guess), the cells aren't interpreted as zeros or empty cells. So, the pie chart may contain one or two 0 percent slices. (Actually, there's a title and a line drawn to one or more non-existent slices.) I would like to avoid such a picture, drawing only non-zero slices. Is there a way to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tweaking Macros | Excel Programming | |||
Code needs tweaking :P | Excel Programming | |||
Tweaking Code | Excel Programming | |||
Tweaking Code | Excel Programming | |||
Formula needs tweaking - HELP!! | Excel Programming |