I'm sure this has been answered before but nothing I've read here has helped
me. I had a chart in a workbook I made in Excel 2003. Worked fine until I
"upgraded" to 2007. The chart gets its data from column K on another
worksheet.

In 2003, it was:
Series Y Values: =Table!$K$4:$K$60000

This worked fine in 2003, but in 2007 it seems to be trying to calculate ALL
those extra rows. I only put them in there to make sure all values got added
to the chart as the number of rows with actual numbers changes (realistically
it would never take up that many rows). 2003 ignored the blank rows, and
although 2007 doesn't plot the empty rows in the chart, the enitre workbook
was S L O W until I changed the last row in the formula to 50 (just to see if
it would speed it up and it did).

So I started reading this forum about dynamic ranges such as the following
lifted in another post: =OFFSET('Sheet1'!$F$2,0,0,1,'Sheet2'!$P$8)

The thing is, I simply can't decypher the OFFSET parameters and therefore I
don't know how to change my formula to work dynamically.

The first "point" in the chart would be from $K$4. The last one could be
$K$50 or $K66, etc..... I need a dynamic formula that will basically start
with row 4 and keep going until it reaches an empty cell.

Any help would be greatly appreciated!!!!

-Kevin