Stacked column, remove label if data is zero

  • Thread starter Thread starter Mr.LuckyMe
  • Start date Start date
M

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,
 
I forgot to mention that I want to remove the data label dinamically and not
manually.

Thanks
 
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
 
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,
 
Back
Top