+ Reply to Thread
Results 1 to 4 of 4

Copy Excel charts to word as picture (but image distorted)

  1. #1
    Forum Contributor
    Join Date
    06-18-2012
    Location
    London
    MS-Off Ver
    Excel 2019
    Posts
    347

    Copy Excel charts to word as picture (but image distorted)

    Hi everyone,

    Is there a way or software that can capture charts in Excel with the best image quality? When I copy charts from Excel to Word as picture, or using snipping tool to grab image, the quality is really bad. I can copy as the source formatting and embed workbook, but I don't want to keep the link.

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    891

    Re: Copy Excel charts to word as picture (but image distorted)

    I am normally using 'LightShot'.
    https://app.prntscr.com/en/download.html

  3. #3
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,878

    Re: Copy Excel charts to word as picture (but image distorted)

    If you want to export chart as vector image (EMF format).

    There are couple of methods.

    1. Using API and clip board. Have a read of link below.
    https://stackoverflow.com/questions/...-to-wmf-or-emf

    2. Copying Chart from Excel into PowerPoint, then using PowerPoint's export function to convert chart into EMF.
    Run the code with the chart object you wish to export selected. Code originally posted by me in another forum.
    Please Login or Register  to view this content.
    Edit: You'd then import the emf file in Word document.
    Last edited by CK76; 06-10-2020 at 08:49 AM.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  4. #4
    Forum Contributor
    Join Date
    06-18-2012
    Location
    London
    MS-Off Ver
    Excel 2019
    Posts
    347

    Re: Copy Excel charts to word as picture (but image distorted)

    Thank you a lot. It works nicely

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA copy excel as a picture to word - zoom picture
    By michelle 1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2016, 06:47 AM
  2. Copy an Image from a User form Picture Box to Worksheet Picture Box
    By sledgehammer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2014, 11:39 AM
  3. Replies: 0
    Last Post: 06-10-2012, 11:17 AM
  4. Pasting charts to Word from Excel as picture
    By Hari in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-05-2006, 03:10 PM
  5. [SOLVED] Distorted Excel chart fonts when copy/paste to Word or Powerpoint
    By JJMB in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-18-2006, 02:45 PM
  6. Charts to Image or Picture?
    By Bill Elerding in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-05-2005, 08:06 AM
  7. [SOLVED] How can I print an excel chart so a picture is not distorted?
    By MJADAMS in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-09-2005, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1