Hello,



I need to chart a series from a column. Problem is i need to include
blanks. My x axis has no blanks and the
=OFFSET(Sheet1!$B$2,0,0,COUNTA(Sheet1!$B:$B)-1,1) works like a charm to
ensure I catch all the dates. But when I use this formula for my data series
(with blanks) it will not count blanks and cannot keep the series data
linked to the correct date.

How could I get around this?

Thanks, Kevin Graham