how to copy a chart from Excel 2011 (Mac) into Word?

Posted on 2014-08-05
Last Modified: 2014-08-28
hi Folks
Just wondering if there is a workaround to the following..I have a customer who is using Excel 2011 on the Mac but doesn't seem to be able to copy in a chart into his Word document. In Office 2013 it's pretty straightforward but he seems to have problems with the picture quality. This is what he is doing at the moment "What I can do is copy as a picture and save as a png file, that works but is still only 150dpi."
Any suggestions?
Question by:agwalsh
    LVL 13

    Expert Comment

    by:Russell Fox
    I tend to work on Windows machines, but if he just needs an image of the chart he might need a better screen capture program. Snip is the one I know for Mac.

    Author Comment

    No, me too. Not a Mac fan myself have to say. I'll pass that onto him...:-)
    LVL 39

    Expert Comment

    I use Office 2011 and it is possible to copy and paste charts from Excel into Word.
    I simply highlight the chart in Excel ... select COPY and then switch to Word and PASTE.

    I've done this with line, pie and other charts and they come across fine.

    I'm guessing that there might be other issues at play here.   Is the user working with newly created DOCX and XLSX files created on the Mac or older DOC/XLS files perhaps?  Or files created on another system?

    There should be NO need to be taking screenshots and pasting images.  OSX has inbuilt screen grab tools (Shift+Cmd+4 will capture any screen area) so there's no need for a 3rd party tool in any case.

    Author Comment

    by:agwalsh what would you recommend? That he upgrades all his documents to the new format (docx/xlsx) or something else? Thanks.
    LVL 39

    Accepted Solution

    Try the following

    Create a new XLSX document and build a simple table and chart .. save as XLSX.
    Open a new word document .. save as DOCX.

    Now try the copy and paste of the chart from the XLSX file to the DOCX file .. if that works then you have a solution.

    If not then we might need to look closer at the office 2011 settings or another cause.  You'll need to check the versions of Office 2011 (in terms of the specific release and if all patches/updates are applied) and the version of OSX.

    Author Comment

    Will pass it on ...thank you :-) Go raibh maith agat ;-)

    Author Closing Comment

    Want to give good feedback but I haven't heard back from the person who asked me :-(

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    Apple's Mac OS X has become an official member of the malware club. The Flashback Trojan has affected over half million Macs, worldwide. It is behavior that ultimately gets malware onto a person’s computer. Obsolete or out-of-date software helps…
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now