Can I formulaically set a cell to blank (non-Text, no value)?
To continue on from these posts;
If your chart data is like this
A B
s 5
d N/A
f 7
g 10
then as stated in the other posts your graph won't plot the N/A but it still
leaves an empty space marked "d".
Can you get the graph to ignore all N/A/0/blank cells and the headings?
wrote in message
ups.com...
No, I tried that. It still leaves a value in there that is graphed as
0. The suggestion above with the #N/A values should work from my
testing.
Thanks TC
|