Stacked column, remove label if data is zero

[Mr.LuckyMe]

I want to create a stack column and include in the data label, the series
name and the value. Is it possible to remove the data label for zero values?

Is it possible to adjust the gap at column level instead of chart level?

Thanks,

 

[Mr.LuckyMe]

I forgot to mention that I want to remove the data label dinamically and not
manually.

Thanks

 

[Klemen25]

After you mark that you want series name and value, you than go to
froamt data labels, and than under custom add 0;-0;;
This will remove zero values and only series name will remain.

Best regards

 

[Mr.LuckyMe]

Thank you for your answer, but I want to remove dinamically the data label
(value and series name) if value=0.

I know I can dellete the data labels manually, but is a very time consuming.

Thanks,