Importing charts from MS Excel

Post questions on how to use or achieve an effect in Inkscape.
seans_potato_biz
Posts: 138
Joined: Mon Apr 07, 2008 6:01 am

Importing charts from MS Excel

Postby seans_potato_biz » Sat Feb 18, 2017 3:25 am

I'd like to import charts from MS Excel 2016 into Inkscape. I can copy the chart in Excel and paste them into Adobe Illustrator just fine (all the components including text can be edited) but if I paste them into Inkscape they arrive as bitmap images. Can I get them into Inkscape but still have them editable and scaleable?
Win 7/10, Inkscape 0.92.2

We don't inherit the Earth from our parents; we borrow it from our children.

theozh
Posts: 437
Joined: Fri Mar 23, 2012 6:30 pm

Re: Importing charts from MS Excel

Postby theozh » Sat Feb 18, 2017 4:39 am

well, a quick and dirty solution would be: export your table as PDF and import it into Inkscape.
You probably need to ungroup several times until you end up with lines, paths and text which can be edited...

edit: I quickly tried with Win7/Excel2013 and Inkscape 0.92, well, copy & paste seem to work. I directly get a table. Although, the table via PDF import looks better. In the copy&paste version numbers are somewhat shifted...
Win7/64, Inkscape 0.92.2

User avatar
brynn
Posts: 10309
Joined: Wed Sep 26, 2007 4:34 pm
Location: western USA
Contact:

Re: Importing charts from MS Excel

Postby brynn » Sat Feb 18, 2017 8:37 pm

I've seen a lot of message where people are having trouble importing from Excel or similar programs.

If Inkscape can't open a file, it imports it as a raster image. I don't know what file format you would be importing, but here's a list of what Inkscape can open natively: https://inkscape.org/en/learn/faq/#what ... portexport

seans_potato_biz
Posts: 138
Joined: Mon Apr 07, 2008 6:01 am

Re: Importing charts from MS Excel

Postby seans_potato_biz » Mon Feb 20, 2017 11:57 pm

theozh wrote:edit: I quickly tried with Win7/Excel2013 and Inkscape 0.92, well, copy & paste seem to work. I directly get a table. Although, the table via PDF import looks better. In the copy&paste version numbers are somewhat shifted...


Unfortunately, I'm trying to copy charts (bar graphs with error bars) and charts don't seem to import the same way as tabulated data.

Exporting charts from Excel as PDFs first before importing into Inkscape works well but it takes longer to do. :(
Last edited by seans_potato_biz on Tue Feb 21, 2017 8:58 pm, edited 1 time in total.
Win 7/10, Inkscape 0.92.2

We don't inherit the Earth from our parents; we borrow it from our children.

theozh
Posts: 437
Joined: Fri Mar 23, 2012 6:30 pm

Re: Importing charts from MS Excel

Postby theozh » Tue Feb 21, 2017 12:56 am

...just double checked...
Well, actually on imported charts via PDF you cannot edit axes text properly. Recently, I just learned in this forum that you have to remove the "Manual Kerns" (Menu ¦ Text ¦ Remove Manual Kerns). But then with a Excel test table the axes text got messed up. Too bad :cry:
So, it probably depends what exactly you want to edit in the Excel table with Inkscape.
(Well, of course you could use gnuplot for plotting your data which has a direct output for SVG.)
Win7/64, Inkscape 0.92.2

tylerdurden
Posts: 2344
Joined: Sun Apr 14, 2013 12:04 pm
Location: Michigan, USA

Re: Importing charts from MS Excel

Postby tylerdurden » Tue Feb 21, 2017 12:59 am

I found in LibreOffice, I can right click and save charts as SVG, maybe in excel too? Then just import.
(copy paste works fine too)

You might even consider using LibreOffice, unless other parts of your workflow require excel.
Have a nice day.

I'm using Inkscape 0.92.2 (5c3e80d, 2017-08-06), 64 bit win8.1

The Inkscape manual has lots of helpful info! http://tavmjong.free.fr/INKSCAPE/MANUAL/html/

seans_potato_biz
Posts: 138
Joined: Mon Apr 07, 2008 6:01 am

Re: Importing charts from MS Excel

Postby seans_potato_biz » Tue Feb 21, 2017 9:54 pm

theozh wrote:...just double checked...
Well, actually on imported charts via PDF you cannot edit axes text properly. Recently, I just learned in this forum that you have to remove the "Manual Kerns" (Menu ¦ Text ¦ Remove Manual Kerns). But then with a Excel test table the axes text got messed up. Too bad :cry:
So, it probably depends what exactly you want to edit in the Excel table with Inkscape.
(Well, of course you could use gnuplot for plotting your data which has a direct output for SVG.)


tylerdurden wrote:I found in LibreOffice, I can right click and save charts as SVG, maybe in excel too? Then just import.
(copy paste works fine too)

You might even consider using LibreOffice, unless other parts of your workflow require excel.


GNUplot looks pretty powerful but also really complicated and time consuming to learn and use and format data in a way that it will accept so I'll try opening my files in LibreOffice to see if that bypasses this problem.
Win 7/10, Inkscape 0.92.2

We don't inherit the Earth from our parents; we borrow it from our children.


Return to “Help with using Inkscape”