| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide items w/a 0 value in a chart?
I am using a pie chart with names as the values descriptions and then the
percentage. I have some names, currently, that have a 0 value. How can I make the pie chart automatically hide the names that have a 0 value? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide items w/a 0 value in a chart?
AFAIK, you can't. You could use =IF(value=0,"",desciption) to have no text
in the legend, but its color would still show. You could manually delete the legend entry, but that is not automatic. The closest you can come is to write VBA code to a change event that would restore the legend and then delete entries that correspond to zero values; it would take some work, but is doable. Jerry "NUMBnut" wrote: I am using a pie chart with names as the values descriptions and then the percentage. I have some names, currently, that have a 0 value. How can I make the pie chart automatically hide the names that have a 0 value? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide previously used items from multiple drop lists | Excel Worksheet Functions | |||
| Chart help Hide Months | Charts and Charting in Excel | |||
| how to make a chart for frequently used items | Excel Discussion (Misc queries) | |||
| tick mark labels | Charts and Charting in Excel | |||
| How can I hide points for future dates on a Year to Date chart? | Charts and Charting in Excel | |||
Linear Mode
