Can you change the size of Graphs in Excel when copying in to Word?

[Steeden87]

Hi all,

Just a quick question: I automated a load of reports here at work and the one thing I can't figure out is to configure the size of a graph when copying from Excel to word. I know you can use the copy as picture function, but that requires more 'thinking' than a simple copy and paste.

Here is what a a graph looks like when copied in to word: https://i.imgur.com/8zMSfFc.jpg

This is what I want it to look like when copied and pasted directly: https://i.imgur.com/Be5NG4Y.jpg

Anyone know how to adjust graphs in Excel to paste full size?

Thanks!