london word training - Pasting excel chart into word

Resolved · Low Priority · Version Standard

Wed 14 Mar 2007, 16:49 Delegate Beth said...

Beth has attended:
Excel Intermediate course
Excel Advanced course

Pasting excel chart into word

when pasting large charts from excel into word how do i adjust the formatting to ensure that the chart fits to a page neatly without keep manually adjusting fonts and row and column widths.

Mon 19 Mar 2007, 10:18 Trainer Amanda said...

RE: pasting excel chart into word

Hi Beth

Thanks for your question.

The only suggestion I would think of would be to try recording a macro that copies and pastes the chart then adjusts the font sizes etc so you don't have to keep doing the same thing manually every time.

Give it a go and see how you get on.

thanks
Amanda

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Word tip:

Making Word file sizes smaller

Word document file sizes can get rather large, particularly when a lot of graphics are inserted into a document.

You can significantly reduce the size of a Word file by opening the document, selecting all the contents (Ctrl + A), then hold down Ctrl + Shift + F9. Then resave the document (saving with a new filename will allow you to be able to compare the file size of this document with the original).

View all Word hints and tips