I am creating a dynamic chart that captures 24 months of data.

I'm using a vlookup to put data into the cells and it goes out 5 years. It
looks like the dynamic chart code picks up the vlookup code 5 years out and
tries to chart it. It also picks up months where no production accured. Is
there away to ignore the vlookup if no data is in the cell?

Here is a sample of my data:

Dec 05 700
Jan 06 725
Feb 06 720
Mar 06 695
Apr 06 710
"blank" "blank"
Jun 06 720
Jul 06 700
"blank" "blank"
Aug 06 710
vlookup code goes out a total of 5 years. So, I have blank cells as of Jan
08 out to 2010. I only want to pickup the last 24 months, where there is data.

I know this is complicated, so, thanks in advance for any help.

--
Baltimore Ravens