Share via

How much does EMF format distort Excel Chart Shape Pasted to PowerPoint ? EMF chosen for text legibility, maximise App reliability?

Anonymous
2023-03-03T06:44:44+00:00

I need help to choose Picture format to paste Excel Chart with text legibility, maximum PowerPoint App reliability.

My reasoning to choose EMF as follows:

  1. default paste options (SVG or Microsoft Office Graphic Object) causing PowePoint to close pre-maturely
  2. retains Text attributes
  3. No reported problem with Bar Graph
  4. when original color is not required
  5. when transparency is not required

My concern of EMF is Chart Shape may change; how to find out how much change to expect?

APPENDIX

PowerPoint Paste Options

when copied from Excel, options are as follows:

  1. Picture (SVG)
  2. Picture (PNC)
  3. Picture (Enhanced Metafile)
  4. Picture (JPEG)
  5. Picture (GIF)
  6. Picture Windows Metafile)
  7. Device Independent Bitmap
  8. Bitmap

when copied from Slide, extra option is "Microsoft Office Graphic Object "

Copy and Paste into new presentation resolved my PowerPoint close after Review shows Compare Result - is it virus related ?

When to choose WMF, EMF or EMF+ format

SVG vs PNG vs JPG: Image Format Pros & Cons

SVGs are more like HTML than simply being an image. As a result, we recommend that web developers not load any SVG as an object or iframe if possible

JPEG is a file that can get infected

https://www.graphpad.com/support/faqid/955/

FAQ: Which image format is best?

Display the properties of an embedded image in PowerPoint

to quote from What's the difference between Microsoft Excel Chart Object and Microsoft Office Graphic Object?

Excel chart objects will retain their Excel characteristics and when they are embedded into Word and then edited, Excel will be the editor.

Graphic objects can be edited with the chart tools that come with Word.

Here is a quote from the article "Copy Excel data or Charts to Word"

  • To paste a chart in another format, click the arrow on the Paste button, and then click Paste Special. In the Aslist, select the format that you want to use.
  • To paste a chart as an embedded object that can be edited by using Excel, click Microsoft Office Excel Chart Object. To insert a file icon that you can click to open the chart, you can select Display as icon.
  • To paste the chart as an Object Linking and Embedding (OLE) Word application icon (rather than pasting the actual chart), click Microsoft Office Excel Chart Object, and then select the Display as icon check box. You can click the icon to open the application and then view the chart.
  • To paste a chart as a static picture, click any Picture or Bitmap option. Picture format generally provides better display quality than Bitmap format.
  • Click Microsoft Office Graphic Object to paste a chart as a graphic object that can be edited by using the chart tools in Word. To insert a file icon that you can click to open the chart, select Display as icon. Microsoft Office Graphic Object is not available when you are using Compatibility Mode in Word.
Microsoft 365 and Office | PowerPoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Steve Rindsberg 99,161 Reputation points MVP Volunteer Moderator
    2023-03-06T16:04:30+00:00

    The information you quoted doesn't mean that the appearance of the chart will change just because it's been pasted as EMF. It means that someone can later ungroup the pasted EMF and make changes to it. This is the case with any vector graphic (EMF, WMF, SVG). Raster or image formats cannot be ungrouped and can't be edited (BMP, PNG, JPG, etc)

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-03-06T04:48:06+00:00

    Dear respected

    Good day! Thank you for posting to Microsoft Community. We are happy to help you.

     

    I’m sorry you’re having a problem with s Excel chart EMF format distort in PowerPoint but based on your description we can work together to resolve it.

    For the situation you encountered, we deeply understand the inconvenience caused and apologize for it.

     

    As per your description, may I know have you tried as a workaround emf export solution. e.g. copy Excel chart then open PowerPoint, go to home tab and click on paste drop down and choose Paste Special ->Picture (Enhanced Metafile). Then right click on image, save as, emf.

    Meanwhile, could you please provide screenshot of how the pasted content (EMF) appear in PowerPoint or even better a sample file for our reference, so we can understand your exact scenario and provide our suggestion in a productive manner, perhaps some related screenshots will be helpful.

    Appreciate your patience and understanding and thank you for your time and cooperation.

     

    Sincerely,

    Waqas Muhammad

    Thanks Waqas,

    Before I recommend my co-workers to paste as EMF, I need help to understand comment by

    EMF files are identified as vectors by PowerPoint, the color and shape can be changed.

    I am hoping Microsoft would provide insight how much of following color and shape will change when pasting, as EMF format, Charts by following Excel Templates

    1. Column
    2. Line
    3. Pie
    4. Bar
    5. Area
    6. XY (Scatter)
    7. Map
    8. Stock
    9. Surface
    10. Radar
    11. Treemap
    12. Sunburst
    13. Histogram
    14. Box & Whisker
    15. Waterfall
    16. Funnel
    17. Combo

    Image

    Was this answer helpful?

    0 comments
  3. Anonymous
    2023-03-03T09:55:35+00:00

    Dear respected

    Good day! Thank you for posting to Microsoft Community. We are happy to help you.

    I’m sorry you’re having a problem with s Excel chart EMF format distort in PowerPoint but based on your description we can work together to resolve it.

    For the situation you encountered, we deeply understand the inconvenience caused and apologize for it.

    As per your description, may I know have you tried as a workaround emf export solution. e.g. copy Excel chart then open PowerPoint, go to home tab and click on paste drop down and choose Paste Special ->Picture (Enhanced Metafile). Then right click on image, save as, emf.

    Meanwhile, could you please provide screenshot of how the pasted content (EMF) appear in PowerPoint or even better a sample file for our reference, so we can understand your exact scenario and provide our suggestion in a productive manner, perhaps some related screenshots will be helpful.

    Appreciate your patience and understanding and thank you for your time and cooperation.

    Sincerely,

    Waqas Muhammad

    Was this answer helpful?

    0 comments