Resize the size of a Chart when pasting from Excel to Word

[OzPanda]

I have some VBA code

Charts("Chart5").ChartArea.Copy
        .Selection.GoTo what:=wdGoToBookmark, Name:="FG5"
        wdApp.Selection.PasteSpecial Link:=False, DataType:=wdPasteEnhancedMetafile, Placement:=wdInLine, DisplayAsIcon:=False

I'm trying to paste into word but the chart just pastes in and is fairly large.

I would like to be able to control the size of how big the chart is.
I also tried just doing wdApp.Selection.Paste

is there a vba code the lets you paste and resize the chart? and make it smaller?

 

[Macropod]

Try inserting your Word bookmark into a table cell with a fixed height and width. Anything pasted there should have its dimensions constrained to the cell size whilst maintaining the original aspect ratio.

 

[Jon Peltier]

In my experience, it's better to size the chart appropriately in Excel, then copy it so it's the right size in Word. It takes a little trial and error ahead of time. Also, it's way more reliable (and conceptually easier) to use charts embedded in worksheets, not charts on their own chart sheets.