excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 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:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function



View all Excel hints and tips


Server loaded in 0.09 secs.