I have a chart that has 2 series (Budget - The green column & Spend - The blue column) where I want to hide labels where there is a zero value.
I also need to show the label to 1 decimal place of the unit type (thousands) but where I have applied the number format of '#""' to the Spend column, it shows with no decimal places.
Is there a way to hide zero values but also have with x decimal places?
TIA
I also need to show the label to 1 decimal place of the unit type (thousands) but where I have applied the number format of '#""' to the Spend column, it shows with no decimal places.
Is there a way to hide zero values but also have with x decimal places?
TIA