ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Do not display Value label if value = zero (https://www.excelbanter.com/charts-charting-excel/262561-do-not-display-value-label-if-value-%3D-zero.html)

LFNFan

Do not display Value label if value = zero
 
Hi

I am putting together a pie chart, where values for some slices is 'zero'.
The zero slice is not visible, but the label still appears '0%'. Is there
any way of suppressing this label for the zero slice only (so the other
slices still have value labels appearing) ?

Many thanks for any help

Luke M[_4_]

Do not display Value label if value = zero
 
Format label, custom format:
#;;;

--
Best Regards,

Luke M
"LFNFan" wrote in message
...
Hi

I am putting together a pie chart, where values for some slices is 'zero'.
The zero slice is not visible, but the label still appears '0%'. Is there
any way of suppressing this label for the zero slice only (so the other
slices still have value labels appearing) ?

Many thanks for any help





All times are GMT +1. The time now is 08:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com