Excel/Word - Copy/Paste graph from Excel into Word

Please offer how I can change the size of a graph that was created, and objects grouped, into Word - without deleting some of the information.

Rather than resizing the graph, and all objects in it, Word truncates some of the information so it is no longer visible.

Thank you.
exp vgAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark BullockQA EngineerCommented:
After pasting the chart,
click it so you see the handles
Hold down the Ctrl key, then click and drag a handle
Paul SauvéRetiredCommented:
You may want to use a screenshot from Excel and paste then into Word or, better yet, use the group feature in Excel to create a single image rather than separate parts―then copy/paste to Word.
frankhelkCommented:
Presuming that you coy/paste a diagram from Excel to word, it depends on "how you paste" ...

Catch the diagram in Excel by selecting it and pressing CTRL-C (or right-click and "copy").

In Word, use "Paste as ..." and choose depending on your needs:

"MS Excel Diagram Object" will embed the complete Excel workbook into your word file, which allows you to edit it afterwards (insert more data, do formatting, etc) as far as Excel itself will allow. It could be resized lossless, but it's disconnected from changes in the original Excel workbook.
"Bitmap" will create a lossless pixel-by-pixel snapshot of your diagram and embed that. This is perfect when used with 1:1 ratio, but will loose quality if resized.
"Image (extended Metafile)" will embed the diagram as vector graphic, which could be resized. No formatting or data changes are possible.
"Image (<type>)" will convert the bitmap to a common format like GIF, JPEG or PNG. That allows to extract the image from the word file later and save it in that format. Since those formats compress efficiently, that would limit the bloating of your Word file. Otherwise similar to "Bitmap", but losses implicated by the formats (esp. JPEG) will apply.
"Microsoft Office Graphics Object" is IMHO similar to "Image (enhance Metafile)" but may offer different advantages.
"Link to original file" will not embed the Excel file like the first option in favor of just embedding a link to it. That would save your word document from bloating, offer the same functionality as embedding the complete file, but will break the function if the Excel file could no longer be found or is unavailable (in that case only a place holding bitmap of the last state will be available)

I'd recommend to play around with the options a bit and find out the best for you. I'd recommend "Image (enhanced Metafile)", embedding the full object or Microsoft Office Graphics object" for best resizability.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
exp vgAuthor Commented:
Thank you.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.