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
Bookmarks