Chip Pearson has pages on his web site (http://cpearson.com) that show how
to compress a range with blank rows. Set this up in the next columns in the
sheet and plot from this new range.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Ravens Fan" wrote in message
...
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