Help on Hiding Label's on pie Chart [SOLVED]

[chris369]

Hi All

On a dash board of mine I have a pie chart which display category and data label's which are 0% which just get in the way - Is there anyway to tell excel to not display category name if the value is 0 ?


I Know i can get rid of the data value by using Custom and type"0%;;;" however the category name stays behind? I would just manually delete these categories of the chart however its an interactive chart and so these 0 Categories may not always be 0 ?


Any Ideas ???


Thanks

 

[Sajan]

Hello Chris,

Are you able to put a value of "=NA()" when a category is zero?


If nothing else works, you could always make your chart data calculated dynamically. See the following post for some ideas:

http://chandoo.org/forums/topic/charting-only-select-cells-based-on-value-from-other-column


Cheers,

Sajan.

 

[Luke M]

As Narayan said, you need to setup some formulas so that when you don't want the category displayed, the formula defaults to NA()

 

[chris369]

Thanks guys I have now fixed my problem.