Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
2945
Treating null values
posted

If I have a Composite Chart with two NumericTimeSeries, but don't have values on all dates for both series, why can't I just graph the values from one point to the next. 

E.g. if I have the following datatable:

Date Series 1 Series 2
01/03/21 10
05/03/21 20 11
06/03/21 30
09/03/21 40 22
11/03/21 50 23
20/03/21 60

It seems the only options I have for Null handling are Zero, InterpolatedSimple, DontPlot or Custom.  I just want to graph directly from one value to the next.  It seems the only way I can do this is to copy my values onto the dates on my other series, like so:

Date Series 1 Series 2
01/03/21 10
05/03/21 20 11
06/03/21 30 11
09/03/21 40 22
11/03/21 50 23
20/03/21 60 23

But this then displays dots on the graph, when there is no change on those dates.

Is there a way to do this?

Thanks,
Campbell

Parents Reply Children