Stacked column, remove label if data is zero
 

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,

Stacked column, remove label if data is zero
 

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

Thanks

"Mr.LuckyMe" wrote:

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,

Stacked column, remove label if data is zero
 

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

Stacked column, remove label if data is zero
 

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,


"Klemen25" wrote:

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