I have a workbook with a worksheet that contains multiple graphs. I need to
create OLE links to each graph and display the in object frames in a MS Access
database. It seems that I need to be able to refer to each graph in the
"language of Excel". I need a way to express the path to the worksheet not just
the workbook and then I need a way to refer to a specific graph on the
worksheet. I have found a reference to Excel's ProgID object identifier but
that's all I have. At this point, all that I have been able to do is display the
whole worksheet so I get all the graphs as well as the spreadsheet rather than
just a graph. Can anyone help me out here.

Thanks!

Steve

I don't believe you can show just a chart if the chart is an embedded
chart. By definition, embedded in a worksheet, it is shown in that
context.

Worse, if the chart in on a sheet by itself, there is no way to create
a hyperlink to that sheet. [In XL, the hyperlink anchor is a cell,
which is a shame because I suspect it could have been made any XL
object.]

--
Regards,

Tushar Mehta (www.tushar-mehta.com) MS MVP -- Excel

In article <2p2Na.23945$(E-Mail Removed)>,
(E-Mail Removed) says...
> I have a workbook with a worksheet that contains multiple graphs. I need to
> create OLE links to each graph and display the in object frames in a MS Access
> database. It seems that I need to be able to refer to each graph in the
> "language of Excel". I need a way to express the path to the worksheet not just
> the workbook and then I need a way to refer to a specific graph on the
> worksheet. I have found a reference to Excel's ProgID object identifier but
> that's all I have. At this point, all that I have been able to do is display the
> whole worksheet so I get all the graphs as well as the spreadsheet rather than
> just a graph. Can anyone help me out here.
>
> Thanks!
>
> Steve
>
>
>