This content has been marked as final. Show 2 replies
Would you check closely because I thought nulls did not display? Zero values do display. I found this useful once.
But typically it is visually unexpected when you have, for example, a zero height 3-D column bar. If you were doing it by hand, you would leave a space but omit the bar all together. I doubt that can be done in a chart.
They had to choose an interpretation. Does zero mean disappear or does it mean chart a zero? I think zeros plot and nulls don't -- what value would they plot?
If indeed nulls do not display, you could preprocess the data changing zeros to nulls before plotting. But be aware that the entire column will likely disappear if all the data entries for a label are null. I'm sure that is what I experienced. Fine if you want that,
In fact, I had multiple data sets to chart: OC data, OO dat, WR data (3 sites, 4 data points per day) which sorted nicely and I added a (0, null, null, null) data point as a spacer between columns.
Perhaps someone else knows of something that can help.