Error : Reference must be made to open worksheet

Question

I'm attempting to use the function offset to implement dynamic graphing. I already created the names for the x- axis and y-axis. I attempt to graph by typing  =series("name of graph", 'Name of excel document.xlsx'!Time, 'Name of excel document.xlsx'!Data,1) but it tells me that the reference must be made to an open worksheet. How do I solve this problem? The information that is named "Time" and "Data" are on the same excel file, but on a different sheet in the file if that could be it,

Answer 1

I'm attempting to use the function offset to implement dynamic graphing. I already created the names for the x- axis and y-axis. I attempt to graph by typing  =series("name of graph", 'Name of excel document.xlsx'!Time, 'Name of excel document.xlsx'!Data,1) but it tells me that the reference must be made to an open worksheet. How do I solve this problem? The information that is named "Time" and "Data" are on the same excel file, but on a different sheet in the file if that could be it,

Yeah, in 2007 simply typing in the named formula doesn't work.  You have to select the chart, then Chart Tools contextual ribbon | Design tab | Data group | Select Data button.  Then, to specify the x-values click the Horizontal Axes Labels section | Edit button and to specify the y values the Legend Entries (Series) section | Add button.

Answer 2

Sounds like you are doing it right. Check that the range names you are using are global in scope as opposed to local to one sheet.