Microsoft KB Archive/69262

{| = Embedding an Excel Chart into an Excel Worksheet =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q69262

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 &quot;Microsoft Excel User's Guide&quot; 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.

The chart will appear on the worksheet and, whenever selected, the formula bar will display the following formula: =EMBED(&quot;ExcelChart&quot;,&quot;Chart&quot;)

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