Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a chart which has both Zero and Null Values.
The Null values mean there is no data to report, but the Zero Values need to be recorded.
Is there any way to display just the data recorded, and to ignore the Null values. I still need to report Zero values.
Thanks
Try removing 'Suppress Zero-Values' Tick in Presentation Setting of the chart.
What does supress nulls actually mean?
If this is selected, will it ignore Zero values too?
'Suppress Zero-Values' will suppress the Zero Values if any
'Suppress Null/Missing' will suppress if values are not present.