In a chart if you display data labels is there a way of avoiding a zero being displayed if the relevant cell is the result of a formula?
It seems that even if the result of that formula is a blank or 'n/a' it is still displayed as 0.
Thanks.
Steve
In a chart if you display data labels is there a way of avoiding a zero being displayed if the relevant cell is the result of a formula?
It seems that even if the result of that formula is a blank or 'n/a' it is still displayed as 0.
Thanks.
Steve
Re: Chart Data Labels Blanks
Many thanks ByTheCringe2. Problems sorted for today.
Don’t have an account yet? Register yourself now and be a part of our community!