posts - 81, comments - 259, trackbacks - 0

How to export Excel plots to a vector image (EPS, EMF, SVG, etc.)


This is a bit of a workaround, but it's the only way I know of to export an Excel plot into a vector format such as EPS or EMF. In my case I needed to export the plot to EPS for inclusion within a LaTeX document.

  1. Create the plot in Excel
  2. Copy the plot and paste it into a new, empty word document.
  3. Save the word document as a PDF. When word exports to PDF it embeds the plot in vector form.
  4. Using Inkscape, import the PDF
  5. In Inkscape, File -> Document Properties -> Resize page to content… -> Resize page to drawing or selection
  6. File -> Save as ->
  7. Select the format you want, SVG, PS, EPS, etc.

And there you have it, publication quality plots from Excel.

Keep in mind that your data values may be extracted through the vector image by someone doing a similar process with your image, i.e., opening it in Inkscape and pulling data points out. It's even worse when you send a plot in a word document; you can often recover the original Excel sheet, including your calculations (not just data!)


Print | posted on Friday, August 31, 2012 10:39 AM |

Feedback

Gravatar

# re: How to export Excel plots to a vector image (EPS, EMF, SVG, etc.)

It's even more intense when you deliver a story in a term document; you can often restore the unique Succeed piece, such as your computations (not just data!)
9/1/2012 3:37 AM | testimonials
Gravatar

# ugg saappaat

Uggs boots keep feet toasty even http://www.uggssaappaatsuomi.org/ in the freezing cold days and ugg saappaat therefore have become the ugg saappaat suomesta first choices of many customers xiaocaicl15. ugg saappaat boots This kind of footwear looks fashionable ugg saappaat oulu and unique and is available in different uggs saarbrĂĽcken styles and colors for your choices. Made http://www.uggstovlerdanmark-s.com/ with twin-faced sheepskin, these boots feel incredible ugg boots udsalg warm and comfortable. Many celebrities are ugg boots dk also spotted wearing them during the winter season ugg boots tilbud to go through the cold winter. But this conception is ugg boots online quite wrong, as wearing them sensibly especially with jeans and feathery coats really looks cool and exquisite. 1
11/13/2012 3:13 AM | Zkjykgsng01
Gravatar

# re: How to export Excel plots to a vector image (EPS, EMF, SVG, etc.)

Hi, I'm having this same issue with Illustrator CC 2015 and Office 2011. Total disaster and a workaround via word or ppt. isn't fixing it... any more ideas?

Thanks.
12/9/2015 2:12 AM | Beth
Gravatar

# re: How to export Excel plots to a vector image (EPS, EMF, SVG, etc.)

in excel select the chart, file->export selected graph into pdf then open it in illustrator and...ist done!
12/1/2016 11:21 AM | Chiara

Post Comment

Title  
Name  
Email
Url
Comment   
Please add 3 and 7 and type the answer here:

Powered by:
Powered By Subtext Powered By ASP.NET