Embedding an Excel Chart into an Excel Worksheet

SUMMARY

There may be times when you will want to have a chart, which does not update dynamically, in a worksheet, but you will still want to be able to edit the values or update the chart. The procedure for embedding a chart into a worksheet that is described on pages 391-394 of the "Microsoft Excel User's Guide" is incorrect. This instruction is actually the description on how to create a linked object (not an embedded object) that is dynamically updated when changes are made to the supporting data.

To create a true embedded chart, do the following:

1. Start up two separate instances of Excel. Because embedding can only take place between applications, you must have both the application that is acting as the embedding server and the application that is acting as the embedding client running simultaneously.

2. Open or create a chart in one instance of Excel (the server application). If the chart exists as a linked object on a worksheet, double-click the chart object to open a window for the chart.

3. From the Chart menu, choose Select Chart.

4. From the Edit menu, choose Copy.

5. Activate the other instance of Excel (the client application) and select a cell in the worksheet into which you want to embed the chart.

6. From the Edit menu, choose Paste.

   =EMBED("ExcelChart","Chart")

MORE INFORMATION

The embedded object carries with it the supporting document that contains all the data used to create the object.

REFERENCES

"Microsoft Excel User's Guide." Version 3.00, pages 325-327.