Excel Graphs

[Cassandra]

I have a worksheet in a workbook with multiple graphs. I'd like to be able to
display each graph in an Access97 report. An unbound object frame seems to be
the tool to use. How do I specify the specific worksheet in the workbook and the
specify a specific graph in the worksheet? I found that with the unbound object
frame I can browse to the workbook but then I get the first worksheet in the
workbook and the entire worksheet rather than just a graph. I found the Source
Description and Source Item properties of the unbound object frame and this
seems to be where I need to define the worksheet and the graph. What do I put in
these properties for a specific worksheet and a specific graph?

Thanks!

Cassandra

 

[Casey]

Cassandra,

These are the instructions for what you are doing
that are found in Access 2000.

1. Open the form or report in Design view.

2. Click Unbound Object Frame in the toolbox.

3. On the form or report, click where you want to place
the chart.

4. In the Insert Object dialog box, click Create From
File, and then specify a path to the file. If you don't
know the path, click Browse.

5. If you want to link rather than embed the chart,
select the Link check box.

6. Select the Display As Icon check box if you want the
chart to appear as an icon.

These instructions say that you are prompted, then
are able to specify a path to the file through the Browse
method.

I hope the information will be of some help.

Casey

 

[Cassandra]

Thanks, Casey!

When you do this you get the entire worksheet in the objectframe. I need to get
just a specific chart on a worksheet into the object frame.

Cassandra