Link from Publisher to an Excel chart

[Guest]

How do I link a chart in Publisher to a chart in Excel, so that the one in
Publisher will be automatically updated if I change the Excel file?

 

[Gord Dibben]

Cathrine

I don't work with Publisher, but when I open Publisher 2003, which I have
installed, and click on Help and "linking" I get a lot of help about linking
Publisher to an Excel file.

The updating can be set for auto or manual....your choice.

Suggest you spend a bit of time with the Publisher Help as I did just now.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Cathrine

Here's the section I would look at.

Create a linked object or embedded object from part of an existing file

Open the file that contains the information you want to create a linked object
or embedded object from, and then select the information.

........................select the Excel chart at this point

On the Standard toolbar (toolbar: A bar with buttons and options that you use to
carry out commands. To display a toolbar, press ALT and then SHIFT+F10.), click
Copy or Cut .
Switch to the file where you want to place the information, and then click where
you want the information to appear.
On the Edit menu, click Paste Special.
Do one of the following:
If you want to create a linked object, click Paste Link.
If you want to create an embedded object, click Paste. In the As box, click the
entry with the file format you want to use.


Gord

How do I link a chart in Publisher to a chart in Excel, so that the one in
Publisher will be automatically updated if I change the Excel file?

Gord Dibben MS Excel MVP