Embedded Chart

Your question is not very clear but I shall attempt to answer it with the following example.

I have done this testing in the 2007 version but I expect the 2010 version to work in a similar, if not identical, fashion.

EXAMPLE ONE - EMBEDDED EXAMPLE

1. In EXCEL I have set up some very simple test data.

In my Workbook I have Worksheets called:-

Sheet3

This contains text data in column A (Married Single Divorced Widowed - just 4 rows of data) AND

percentages in column B (45% 22% 25% 8%)

Chart1

This contains a pie chart for the data in Sheet3.

2. I am now going to EMBED the pie chart into a WORD document that I have already set up.

To do this I take the following actions:-

3. Click on the Worksheet called:-

Chart1

 - and click somewhere on the chart so that it becomes highlighted.

CTRL-C

 - to copy the chart.

4. Open the WORD doc into which you are going to embed the EXCEL Chart then:-

Home tab

Clipboard group

Click on the drop down arrow beneath:-

Paste

 - then click on:-

Paste Special . . .

The:-

Paste Special

 - window should open.

5. In the:-

Paste Special

 -window in the field called:-

As:

 - click on:-

Microsoft Office Excel Chart Object

 - so that it's highlighted in blue then click on:-

OK

The chart should now get copied into WORD.

6. Double click the chart so that, in WORD, you can now see the Worksheets:-

Chart1

 - and:-

Sheet 3

7. Click in:-

Sheet3

 - and change the percentages in there. (I changed them so that I had 4 lots of 25%).

8. Now click back on the tab called:-

Chart1

Click somewhere outside of the chart so that it becomes deselected.

Print Preview the document and make sure that you just see the pie chart (I saw exactly this on page 1 of my WORD document).

Save the WORD document.

You have just edited the embedded EXCEL object in WORD and not in EXCEL.

If you go back to your EXCEL Workbook you should see that the values that you changed at step 7. above are not reflected in EXCEL - they are shown in WORD only.

This is what the embedded object in WORD does: it works independently from the originating EXCEL source.

EXAMPLE TWO - "NON EMBEDDED" EXAMPLE

9. Using the same EXCEL and WORD files that we used above click on the EXCEL chart once again so that it's highlighted then:-

CTRL-C

 - to copy that chart.

10. Click in the WORD document (I clicked in page 2) then:-

CTRL-V

 - to paste.

11. You should see the chart pasted into your WORD document.

However, if you now double click this chart that you have just pasted it will not, "open up" as it did in step 6. above: i.e. we cannot edit the pasted object because we have not embedded it as we did in EXAMPLE ONE above.

Can you now see the difference between an embedded and a, "non embedded" object?

If you can please vote as helpful.

Thanks.