+ Reply to Thread
Results 1 to 2 of 2

Changing the default chart/graph format copied from Excel pasted into Word (Office 2010)

  1. #1
    Registered User
    Join Date
    08-28-2012
    Location
    Boston
    MS-Off Ver
    Excel 2010
    Posts
    1

    Changing the default chart/graph format copied from Excel pasted into Word (Office 2010)

    Hi, I work with a team of users that are continually publishing reports in Word that contain charts and graphs copy and pasted from Excel into Word 2010.

    We have a custom script that leverages a PDF engine to automatically convert .doc files to .PDF files that we distribute electronically to our clients. This all works great, but only if all my users select 'paste special' and Enhanced Metafile Format when adding their excel charts into our reports. Most of these people aren't tech savvy, and I'm havin ga hell of a time getting them to follow this workflow and am hoping there's a way in Office 2010 to select the default paste from excel into word when the content is a chart.

    It seems like the default paste from excel is an embedded chart/graph that you can then further manipulate each component of the chart in Word; the default doesnt' paste an actual image. I am assuming the pdf renderer is using a lower resolution .PNG version of the image and when these are scaled for print and or pdf, they look like crap.

    Is htere anyway I can automatically change the default paste format for the chart from excel into word to be an EMF/EMV (enhanced metafile?) Either thorugh the registry or some other saveable setting?

    Thakns everyone!
    Last edited by chaxey; 08-28-2012 at 10:20 PM.

  2. #2
    Registered User
    Join Date
    01-27-2014
    Location
    beijing, china
    MS-Off Ver
    2010 office word
    Posts
    1

    Question Re: Changing the default chart/graph format copied from Excel pasted into Word (Office 201

    I have had the same problem, and have simply had to make "Please use Paste Special-->as Enhanced Metafile" part of new employee training. We have about 200 users and so far that has worked out OK, but I'd like to know, too, if there is a setting somewhere for this.

    Just curious, if it's convenient to divulge: what else does your custom script do besides Save as PDF / Print to Acrobat Distiller?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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