Dynamic Range Graph with data in separate file?

I've perused the threads and I can't seem to find one that has already answered this.
Is it possible to create a dynamic range graph (with named ranges) in one file with the data to run the graph in a totally different file?
I've tried but it doesn't seem to work, keeps reverting to a fixed range.
Working in 2010.
Thanks.

Andy,

Glad to see your test works. I've included the two files with which I am working. Probably doing something wrong that I can't see.
BTW, the SERIES function does not seem to work for me in 2010 (maybe because I'm working in French), as it doesn't seem to acknowledge it.

Thanks. It's what I thought; OFFSET doesn't seem to acknowledge "offline" workbooks. And since for security reasons, I can't put the data in the same workbook, it won't work.
I'm just thinking out loud here, but would it work if I mirrored the data from the offline workbook into the local workbook and then charted from that data? I could always hide the mirrored data sheet or will OFFSET also not acknowledge mirrored data from an offline source?