Hyperlinks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brian - 21 Nov 2003 18:00 GMT

How do I reference a specific Chart in an Excel Workbook
in a Word hyperlink? I can create the hyperlink to the
workbook just fine, it's just that I want it to link to a
specific tab in the workbook that is a chart.

Reply to this Message

macropod - 21 Nov 2003 21:26 GMT

Hi Brian,

If you select & copy the chart in Excel, then go into the
Word document and use Edit|PasteSpecial|Link, you'll get a
linked version of the chart as an INCLUDETEXT or
INCLUDEPICTURE field, with the correct syntax for the
chart referencing. You'll be able to view the field's
coding by selecting the chart in word and pressing Shift-
F9.

Copy that referencing into your HYPERLINK field (again via
Shift-F9) and things should work OK.

Cheers

>-----Original Message-----
>How do I reference a specific Chart in an Excel Workbook
>in a Word hyperlink? I can create the hyperlink to the
>workbook just fine, it's just that I want it to link to a
>specific tab in the workbook that is a chart.
>.

Reply to this Message