Null values actually being null in line charts
Hello!
Line/Spline charts show a huge drop when the next value is null: in this case, there is a 4.68 value for March but there are no value for April... and yet the chart shows a transition to 0, which is totally confusing (and depressing!)
I added the footnote explaining the situation, but it would be better if we didn't need to do that.
Cheers!
Gonza
-
Hi Gonza,
Changing the X-axis type should do the trick. If you change it to number - Linear Axis It should plot the nulls as empty. Not exactly sure how it will treat the string months. You might have to convert to numeric months for it to work properly. Let me know if this works for you.
Brigham
Please sign in to leave a comment.
1 comment