M
maluguitarist
Hi all, I've been trying to plot a chart so that the scatter plot wil
not connect lines to a null point, I want the lines to connect t
points that represent any number, from 0 to infinty. But if the cel
has no value in it yet, I don't want it to be connected by a line t
any other point.
The points that are being connected are calculated by a formula, so th
cell will never be blank.
But only when it is blank will it do what I want. Any other way that
try to represent a blank cell, it connects as if it were a 0. ("" doe
not work)
My question is, in the equation below, what should I put in place o
"NA()" to best represent a true blank cell?
=IF(OR(G3=0,G18=G7), NA(),G27/G3*1000000)
There are 12 points, so if the values from the formula turn out to be
N/A, N/A, N/A, N/A, N/A, 3, 8, N/A, N/A, 8, 9, 10; where N/A means tha
it should be a blank cell. I'd like to have 3 and 8 connected, and 8
9, and 10 connected.
Thank you,
Ale
not connect lines to a null point, I want the lines to connect t
points that represent any number, from 0 to infinty. But if the cel
has no value in it yet, I don't want it to be connected by a line t
any other point.
The points that are being connected are calculated by a formula, so th
cell will never be blank.
But only when it is blank will it do what I want. Any other way that
try to represent a blank cell, it connects as if it were a 0. ("" doe
not work)
My question is, in the equation below, what should I put in place o
"NA()" to best represent a true blank cell?
=IF(OR(G3=0,G18=G7), NA(),G27/G3*1000000)
There are 12 points, so if the values from the formula turn out to be
N/A, N/A, N/A, N/A, N/A, 3, 8, N/A, N/A, 8, 9, 10; where N/A means tha
it should be a blank cell. I'd like to have 3 and 8 connected, and 8
9, and 10 connected.
Thank you,
Ale