ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Copy chart from Excel to Word (https://www.excelbanter.com/charts-charting-excel/167455-copy-chart-excel-word.html)

Medea

Copy chart from Excel to Word
 
When I copy a chart/ graph from excel 2007 and paste it into a word doc it
changes the format (i.e., makes it too big or cuts off some of the graph or
legend). In Office 2000 I was able to double click on the chart once in word
and modify it but I can't do that now. Any suggestions for copying charts
without them being modified?
--
Thanks, Medea

John Mansfield

Copy chart from Excel to Word
 
I would suggest copying the chart as a picture and then pasting that picture
into your Word document. You won't be able to make changes in the Word
document, but the formatting of the chart remains in tact.

Jon Peltier has a very detailed writeup on this subject on his site. Please
see the link below.

http://peltiertech.com/Excel/XL_PPT.html

--
John Mansfield
http://cellmatrix.net





"Medea" wrote:

When I copy a chart/ graph from excel 2007 and paste it into a word doc it
changes the format (i.e., makes it too big or cuts off some of the graph or
legend). In Office 2000 I was able to double click on the chart once in word
and modify it but I can't do that now. Any suggestions for copying charts
without them being modified?
--
Thanks, Medea


Jon Peltier

Copy chart from Excel to Word
 
Another important step is to make the chart the size you need in Excel,
before you copy it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"John Mansfield" wrote in message
...
I would suggest copying the chart as a picture and then pasting that
picture
into your Word document. You won't be able to make changes in the Word
document, but the formatting of the chart remains in tact.

Jon Peltier has a very detailed writeup on this subject on his site.
Please
see the link below.

http://peltiertech.com/Excel/XL_PPT.html

--
John Mansfield
http://cellmatrix.net





"Medea" wrote:

When I copy a chart/ graph from excel 2007 and paste it into a word doc
it
changes the format (i.e., makes it too big or cuts off some of the graph
or
legend). In Office 2000 I was able to double click on the chart once in
word
and modify it but I can't do that now. Any suggestions for copying charts
without them being modified?
--
Thanks, Medea




Medea

Copy chart from Excel to Word
 
I am using excel 2007 and I do not see an edit menu and I can't figure out
how to copy it as a picture??

--
Thanks, Medea


"John Mansfield" wrote:

I would suggest copying the chart as a picture and then pasting that picture
into your Word document. You won't be able to make changes in the Word
document, but the formatting of the chart remains in tact.

Jon Peltier has a very detailed writeup on this subject on his site. Please
see the link below.

http://peltiertech.com/Excel/XL_PPT.html

--
John Mansfield
http://cellmatrix.net





"Medea" wrote:

When I copy a chart/ graph from excel 2007 and paste it into a word doc it
changes the format (i.e., makes it too big or cuts off some of the graph or
legend). In Office 2000 I was able to double click on the chart once in word
and modify it but I can't do that now. Any suggestions for copying charts
without them being modified?
--
Thanks, Medea


Jon Peltier

Copy chart from Excel to Word
 
You have to know the secret hiding place. It's on the Paste button, in the
vicinity of Paste Special. If you can find Paste as Picture, you'll see Copy
as Picture. (I don't have 2007 on this machine, so I can't tell you more
precisely.)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Medea" wrote in message
...
I am using excel 2007 and I do not see an edit menu and I can't figure out
how to copy it as a picture??

--
Thanks, Medea


"John Mansfield" wrote:

I would suggest copying the chart as a picture and then pasting that
picture
into your Word document. You won't be able to make changes in the Word
document, but the formatting of the chart remains in tact.

Jon Peltier has a very detailed writeup on this subject on his site.
Please
see the link below.

http://peltiertech.com/Excel/XL_PPT.html

--
John Mansfield
http://cellmatrix.net





"Medea" wrote:

When I copy a chart/ graph from excel 2007 and paste it into a word doc
it
changes the format (i.e., makes it too big or cuts off some of the
graph or
legend). In Office 2000 I was able to double click on the chart once in
word
and modify it but I can't do that now. Any suggestions for copying
charts
without them being modified?
--
Thanks, Medea





All times are GMT +1. The time now is 05:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com