Export Excel graphs as vector graphics files (e.g. SVGs)?
Become or hire the top 3% of the developers on Toptal https://topt.al/25cXVn
--------------------------------------------------
Music by Eric Matyas
https://www.soundimage.org
Track title: Quiet Intelligence
--
Chapters
00:00 Question
00:56 Accepted answer (Score 12)
02:06 Answer 2 (Score 14)
02:46 Answer 3 (Score 7)
03:20 Answer 4 (Score 4)
04:01 Thank you
--
Full question
https://superuser.com/questions/415707/e...
Question links:
http://www2b.abc.net.au/science/techtalk...
--
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.