Thread: How to add a named range of dynamic data to a graph

Hi, I have the following named range below, I was wondering how I would go about linking this to a graph so the results are updated each time a macro is run.

=OFFSET(InterestRateSim!$D$8,0,0,COUNTA(InterestRateSim!$D:$D),1)

I have attempted to add the data by right clicking a blank graph, clicking on the "select data" button and then pasting this: "=OFFSET(InterestRateSim!$D$8,0,0,COUNTA(InterestRateSim!$D:$D),1)" into the chart data range.

however i get the error message "that function is not valid"

I would really appreciate a hand with this

thanks

Hi,

to update the graph when the data in the dynamic range grows or shrinks, use the range name in the Chart Source Data definition, like this

MyRange is your range name, defined by your Offset function.

=Sheet1!MyRange

is what you enter as the data source. You need to precede the range name either by a sheetname or by the file name in square brackets

[myfile.xls]MyRange

This will update the chart, regardless of whether a macro is run or not.

There's a good example of how to do this at http://office.microsoft.com/en-us/ex...098011033.aspx