I have a macro (see below) that creates a chart. It works in 2003. In 2007, when I add the data series, it doesn't add the part of the range that contains blanks. I then have to go into the chart by hand and reset the range for the series to include leading blanks.

Is there a way to force it to keep the entire range or is this just a known bug?

Thx

Mark Jackson

Set c = ThisWorkbook.Charts.Add
c.Move , sws
For Each s In c.SeriesCollection
s.Delete
Next s
c.ChartType = xlColumnClustered
c.DisplayBlanksAs = False
c.SeriesCollection.Add Source:=sws.Range(Cells(tRowImpl + i, lCol), Cells(tRowImpl + i, rCol)) <- This line should set the range from C100 to AZ100. Since there are leading blanks in the row, it ends up set as AB100 to AZ100 in 2007. It works in 2003.