[Resolved]Empty, Null, and Nothing, oh my! Charts in Excel.

[Bartender]

So, I need to read data from excel cells into an array, and then use the array to act as X and Y values for charts that the program creates.

The problem is that some of the cells are blank-- so I want the chart to not count the blank cells, as if I highlighted them in excel. However, even though I skip these blanks and leave the array location "Empty," it also calls that "zero," which pretty much ruins the graph. I can't just skip zero values in the plotting, even if that were possible, because there are some valid zero values.

Any ideas on how to make VBA think "" instead, or something like that?
Thanks