T
THOMAS CONLON
I have an X-Y scatterplot. In some of the cells in the range for Y values,
the result is #VALUE. However, the chart plots this as if it were "0".
This seems dangerously wrong to me, seems like it should be plotted as if
that cell were blank. It is very misleading in the chart to see those
values plotted as "0". "0" is a possible true and correct value in this
particular data, but those cells do not have that value, so it should not be
plotted as if it were that value.
At any rate, is there any way around this [bad] behavior?
Thank you. Tom Conlon
the result is #VALUE. However, the chart plots this as if it were "0".
This seems dangerously wrong to me, seems like it should be plotted as if
that cell were blank. It is very misleading in the chart to see those
values plotted as "0". "0" is a possible true and correct value in this
particular data, but those cells do not have that value, so it should not be
plotted as if it were that value.
At any rate, is there any way around this [bad] behavior?
Thank you. Tom Conlon