How to copy charts into a word processor
Powered by
EMF
HTML Form
Report Abuse
Weird News When copying charts into a word processor, whether in Microsoft Office from Excel to Word or in openoffice.org from Calc to Writer, the software embeds a special object that links back to the original spreadsheet. If you then change the details in the Excel spreadsheet the chart in the Word document will change accordingly. In many cases this is advantageous; however, it can cause problems if the Word document cannot 'see' the Excel file, for example, if you email the Word file to someone without the Excel file. It is generally better to paste the chart as an image in the first place using the 'Paste special' facility.I will start by explaining how to do this in Microsoft Office:
Once you have created your chart in Excel you select it and copy it, as shown here.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVuFXfNofYqLHqatPpJUgmOkb8x-Ycc5BmPcU316V1DldqV-nxzgjlKqkBZhJrmR1MicyT6gMJdyqdhyphenhyphensOGLD_Ywyf2sERctesRWeKCucQV-VcIjJ4AyTJ0_9_937HqXvt9gYmXyT8T-R0/s400/chart2.jpg)
In older versions of Word you pull down the 'Edit' menu and select 'Paste Special'. You may have to wait a moment for all the menu items to be revealed.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYZNkkJgpZXuMhV_RRzLwjeQyXqjFhtHn69XsiYFwXC_w9Dq_YMN3n2THOyt8KkvZc166sRoSsioGKL0FiMvJ6nG-Vbhz9V1BNu7eDlmVQaryyRJi5KfasKP_EDY3DwbOd_8ONPy9LK55p/s400/chart3.jpg)
In the latest versions of Word, 'Paste special' is in a menu underneath the 'Paste' button.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_-TJdpviba5wzVyKkvSzGcWpT9HClFq28QeX4o8nS_k2OGv3hcS_wNwrlGiVXfjsc7ZJtXh63Em1hhjBZTu9sSGMWVC9H6aj_qiHwJRp2PW8jhJCIAZEV8tf_brZGj-Z9gLB7fcZw_qBC/s400/chart6.jpg)
A box will open, from which you select 'Picture (Enhanced Metafile)', and click OK.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEpUXPMjYZBWdUNmRDWjClSg5hndh2LqaIowVAMtq-bVRwNFg2AzYoUCGq5ehK0kUKQd_VFd8Il746M2t4dAaREsirL5LtHlyowlPDTdwlDbZY-6412NgFrMBjxZjDP_qJGQ-EfY4_AcPI/s400/chart4.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmoGheRrP-3tSnZe6iPv8qeNXh57QdLYpcD2uAws-luGpeHcSue__LH3y5kWEbKDZr6PPCPqF6pwbQm5DufHv4kRpkccQQ2KTLyKAgU7-fLICBRPXWfy3N2zwO-h0tFYvdD3_9_dXNVQPX/s400/chart5.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyuXSfIu4n0Ys5CuXYgnyYvi-oeU1-ew2-aXfhVUnyoSGpdMvm5iNaHz-234RoqZy0-UpoA-uvmXHE513o5fkhdp-OLzRccdiOSqtaFpR5a5NZiW7JZm5RTUDkoih-fYv8pXrGSvODA-Np/s400/chart7.jpg)
Post a Comment