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
- Select your Microsoft Excel plots.
- Copy.
- Open Microsoft PowerPoint.
- Paste-special as enhanced metafile (EMF) into an otherwise empty slide.
- Save your PowerPoint slide as an "other format" file, and choose "EMF" (Enhanced Windows Metafile).
- Import your EMF file into InkScape and ungroup the object.
- 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.