The Computer Oracle

Export Excel graphs as vector graphics files (e.g. SVGs)?

--------------------------------------------------
Rise to the top 3% as a developer or hire one of them at Toptal: https://topt.al/25cXVn
--------------------------------------------------

Music by Eric Matyas
https://www.soundimage.org
Track title: Realization

--

Chapters
00:00 Export Excel Graphs As Vector Graphics Files (E.G. Svgs)?
00:36 Answer 1 Score 14
01:08 Answer 2 Score 7
01:30 Answer 3 Score 3
01:49 Answer 4 Score 4
02:20 Thank you

--

Full question
https://superuser.com/questions/415707/e...

--

Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...

--

Tags
#microsoftexcel #openofficecalc #vectorgraphics #svg

#avk47



ANSWER 1

Score 14


  1. Select your Microsoft Excel plots.
  2. Copy.
  3. Open Microsoft PowerPoint.
  4. Paste-special as enhanced metafile (EMF) into an otherwise empty slide.
  5. Save your PowerPoint slide as an "other format" file, and choose "EMF" (Enhanced Windows Metafile).
  6. Import your EMF file into InkScape and ungroup the object.
  7. Delete all the A4-sized crappy blank space from the image and enjoy.



ANSWER 2

Score 7


Try Gnumeric. It supports exporting graphs to SVG natively. There's a windows version, too. So, the toolchain would be Excel -> Gnumeric -> SVG, or even Gnumeric -> SVG without using Excel. IMHO it's the easiest way to get your graph in SVG.




ANSWER 3

Score 4


Using Excel 2007 under Windows XP, I also discovered that copied graphs get pasted as bitmaps in Inkscape. This is different than the behaviour of Excel 2003 on Windows 7.

I found a workaround -- if you select the cells surrounding the graph (which would include the graph as well) and copy, you can paste a vector graphic in Inkscape just as expected. The only slight downside is that you have to manually remove the grid of excel cells which is left below your graphics.




ANSWER 4

Score 3


Newer versions of PowerPoint allow you to Save&Send as PDF. Use that feature to create a PDF file, then open that in Inkscape and edit by ungrouping, then resize the page to the drawing and save as SVG.