I am trying to create a chart that will automatically update as new data is added.

My spreadsheet is laid out like below

Column A // Column B // Column C // Column D // Column E
Row 43 Cost Data // 2/14/2010 // 2/28/2010 // 3/14/2010 // 3/18/2010
Row 44 GS // 1.00 // 1.25
Row 45 SW // 1.15 // 1.20
Row 46 SE // 1.10 // 1.21

// indicates seperate columns

I am trying to create a dynamic name range that I can use for the chart that will update the X and Y Values as new rows are filled in.

Here is what I have done so far.

XValues =OFFSET('CostData.xls'!YValues,-1,-1)
YValues =OFFSET('CostData'!$A$43,0,0,COUNTA('CostData'!$A: $A),COUNTA('CostData'!$1:$1))

I can not seem to get the name ranges setup correctly.