EmptyValue Approximation and multiple empty values in a row

Baris

I find that if I have EmptyValue.Mode set to Approximation, I get undesired results in my graph if I have multiple values missing in a row. For example, if I have these consecutive values in my series:

1, 2, <empty>, <empty>, <empty>, 3, 4, 5

The dotted line looks like it is using:

1, 2, 2.5, 2.5, 2.5, 3, 4, 5

In this series, I would expect the approximation to result in, or even just 1, 2, 3, 4, 5:

1, 2, 2.25, 2.50, 2.75, 3, 4, 5

I would actually like to ignore those three data points entirely.. Consider this data:

0.05 1 5
0.10 2
0.15
0.20 6
0.25 7
0.30 3
0.35 4
0.40 5 9

I essentially want the empty fields to be ignored for each ChartSeries, or approximated better than I described above (2.5 for all three missing values in the second column). Is there a mode I can set in the approximation that I'm missing, or is what I'm getting the only possible behavior? The only two EmptyValue modes I see are "Zero" and "Approximation", neither of which do what I want.

Baris

Thanks for your reply. I'm already doing that, which in my case is resulting in lots of empty/invisible segments in the line. Wouldn't it make sense to be able to have a mode where those segments are just connected with a single line, like the other parts of the line chart are (where there are no empty values)?

This would be like having a third approximation mode, something like Ignore or None.

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks or appropriate markings.