I am attmepting to graph data that includes both numerical values and
non-numerical (i.e., "") values. The data is as follows:
A B C D
E
(row 1) 10/01/05 11/01/05 12/01/05 TOTAL
(row 2)# Accounts 62 3 65

Since data for D2 (december of 05) does not yet exist, I don't want anything
in that cell (I have a formula that places "" in that cell in that scenario).
But my problem is that when I graph A2:D2, D2 is interpreted as a 0 and not
as the absence of a number.

How do I get Excel to only graph the first two values in that range without
changing the range (the example above is a small section of a 8 MB file).

Thanks,

Jim