This question is locked. New answers and comments are not allowed.
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.
Thanks,
Baris
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.
Thanks,
Baris