Jon - that's fine, but I want to use named ranges in my chart. Here's what I
am trying to do. I have a word document that includes an embedded sheet that
can contain up to 32 data points. I have graph_x and graph_y defined
dynamically to represent the length of the data set. The problem is using
these named ranges in the source data dialog. As you know, the normal syntax
includes the name of the workbook followed by a ".xls". I tried to find out
the name of the embedded sheet by doing a query in the immediate window in
VBA, and here is what I got:

Worksheet in C: QC QC standard procedures Official Procedures STP-QC-12.doc

I think you can see my problem. I am starting to suspect there is no way to
do this wihtout invoking VB, which I am hesitant to do because of my lack of
familiarity with Word objects.

Thanks for any help you can offer.

"Jon Peltier" wrote:

If the entire workbook is embedded, a quick test here shows that you can use
simply the 'Sheet1!$A$1' link referenced just to the worksheet. ThisWorkbook
is only known to VBA.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Wazooli" wrote in message
...
Does anyone know how to reference dynamicially named ranges in a chart
contained within an embedded chart in MS Word? I know how to do this in
Excel, but the name of the workbook is needed. As far as I can tell, the
name of the embedded book in Word is "ThisWorkbook", but I get an error
when
I try to use it.