Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2003

Carol has attended:
Excel Intermediate course

Excel

Can charts be copied into word without an area around them? i.e reducing the area of white space around them

RE: Excel

Hello Carol

Thank you for your question and welcome to the forum.

As far as I'm aware, a chart can only be copied and pasted into Word by selecting the whole chart, including the white area around it.

What you can do is crop the chart once it has been pasted and so reduce the amount of white area around it.

To use the Crop tool, you'll need to bring up the Picture toolbar in Word (View - Toolbars - Picture).

The Crop tool is roughly in the middle of the Picture toolbar. Once selected you can position your mouse over any of the handles around the edge of the chart, and drag in toward the middle of the chart to chop the white bits off the sides.

There is a link below to a video on YouTube which shows you how the crop tool works, if you have a look at it you'll have to wait through the bit while the person puts an image into the Word document first, but afterwards it goes through how to crop something. It's not the clearest video but might help you to see how the crop tool works:
http://www.youtube.com/watch?v=YNN9nnfzOII

I hope this helps.

Kind regards
Amanda

Mon 30 Mar 2009: Automatically marked as resolved.

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.13 secs.