Importing charts to Word

  • Thread starter Thread starter David
  • Start date Start date
D

David

I am trying to import a chart to word. Have trouble
fitting it onto the page page so wish to reduce the size,
However after I reduce it I only seem to end up with a
very small chart and a lot of wasted space around it. Can
I crop off the unused areas of the chart box or is there
another way?
 
David -

Are you using a chart sheet? Reducing the plot area of a chart in a
chart sheet will leave all that white space as part of the copied chart.

Right click on the chart and choose Location from the pop up menu.
Select the As Object In option, and select one of the worksheets in the
workbook. Now adjust the size of the entire chart object, and make the
plot area of the chart as large as you can fit. Make the whole chart the
same size as you want the chart to be in Word, so it does not need to be
scaled after it's pasted.

Now copy and paste this embedded chart.

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