i would like to create a chart wherein the zero values need not be plotted on a graph.In other words, I would like to create a chart excluding the null / zero values,. Please provide some guidance on the same. Existing chart screenshot is attached herewith for your ready reference.
I have tried your solution . Filtering the zero values is also resulting in hiding of the concerned timeperiods on the x axis. I would like to know if there is a solution wherein the x axis would display all the time periods irrespective of the quantities against them; only the chart plot needs to be blank for zero values.
I mean the chartline should be truncated at points where values are zero ( though their corresponding time periods would still remain plotted on x axis). When we filter the values, the corresponding time periods also get hidden. We would still want such time periods also to be displayed on the x axis.
Do you mean for points where the value = 0, you still want to show the time, but not the value = 0?
For example, assuming we have Jan = 1, Feb = 0, Mar = 5; you want to show a graph where Jan, Feb and Mar are still on the x axis; and the line connects from value = 1 to value = 5, instead of 1 to 0 to 5?