 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / October 2006Excel chart in MS Word
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. 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 _______ > 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. 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. > 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 [quoted text clipped - 13 lines] > > when > > I try to use it. Define your ranges as sheet-level names. This means when entering the name, use Sheet1!MyName rather than just MyName. (Jan Karel Pieterse's Name Manager at http://jkp-ads.com can easily convert global to local names.) The chart no longer cares what the workbook name is. The series formula says: =SERIES(Sheet1!$C$4,Sheet1!myX,Sheet1!myY,1) Even if I create the name based on the Excel worksheet, after I paste it into Word, the reference still works. The series formula looks like: =SERIES(Sheet1!$C$4,'Chart in Document4.doc'!myX,'Chart in Document4.doc'!myY,1) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > Jon - that's fine, but I want to use named ranges in my chart. Here's > what I [quoted text clipped - 41 lines] >> > when >> > I try to use it. Got it about half an hour ago, but thanks for your help. As an adjunct question, is it possible to dynamically set the axis titles? > Define your ranges as sheet-level names. This means when entering the name, > use Sheet1!MyName rather than just MyName. (Jan Karel Pieterse's Name [quoted text clipped - 61 lines] > >> > when > >> > I try to use it. Select the title, click in the formula bar, type = (the equals key), then click on the cell you want linked to the title. This works for chart title, axis titles, textboxes, and data labels. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > Got it about half an hour ago, but thanks for your help. As an adjunct > question, is it possible to dynamically set the axis titles? [quoted text clipped - 77 lines] >> >> > when >> >> > I try to use it. Sorry about that - I should have said in the same embedded workbook in my Excel sheet. As far as I can figure, this is not something that was ported to the workbook fucntionality in word documents. I tried the usual ways that always work in Excel, and none of them did. > Select the title, click in the formula bar, type = (the equals key), then > click on the cell you want linked to the title. This works for chart title, [quoted text clipped - 88 lines] > >> >> > when > >> >> > I try to use it. Why not do the workbook stuff in Excel, and when it's all done, except for changing the values in the cells, paste it into Word? KISS, eh? That said, I just pasted a chart into Word, double clicked the chart so it was open in Excel within the Word document, and used the technique I described to link the chart title and both axis titles to cells in the embedded workbook. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > Sorry about that - I should have said in the same embedded workbook in my > Excel sheet. As far as I can figure, this is not something that was [quoted text clipped - 105 lines] >> >> >> > when >> >> >> > I try to use it. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.