Forum: Inkscape Importing graphs from Excel

56ec01a5220915dd463db71ba225796a?d=identicon&s=25 Jurgen Gaeremyn (Guest)
on 2013-04-14 12:37
(Received via mailing list)
Hello list,

for an article I need to edit a graph made in Excel (2007).

This is my current workflow:

1. In Excel: Print to PDF (using Cute PDF)
2. Open the PDF file in Inkscape

The big caveat is: text items don't behave well at all. They are really
naughty :p
-> when changing fonts or size, the spacing doesn't adapt (so text gets
squashed when a bigger font is chosen)
-> certain text elements that don't belong together, all of the sudden
become one item (f.e. the scale items and the R text, but the  is a
different text block)

Currently, the only solution I see, is retyping all the text manually.
Obviously, this is quite a waste of time.

I hope some of you know a better solution for this...

Thanks,
Jurgen.
2bbee79a6e24a65dd6c67778303c2bc5?d=identicon&s=25 Alex Mandel (Guest)
on 2013-04-19 20:06
(Received via mailing list)
Sadly, Excel has extremely limited graphics capability. If you really
want a graph you can edit, use R to make the graph from the excel data.
That can be saved as svg or pdf in true vector format that is completely
editable. Course you might not need to edit it if you use R to its
potential.

Enjoy,
Alex
340db464063049cf1c1527b5ed80a24d?d=identicon&s=25 darkweasel (Guest)
on 2013-04-19 23:07
(Received via mailing list)
Am 2013-04-14 12:36, schrieb Jurgen Gaeremyn:
> I hope some of you know a better solution for this...

Can your diagrams be satisfactorily opened in LibreOffice Calc?
Otherwise perhaps you could even make them there in the first place? You
can copy diagrams from Calc to Draw, then export from Draw to SVG - this
preserves the text, at least in my tests.
Please log in before posting. Registration is free and takes only a minute.
Existing account

NEW: Do you have a Google/GoogleMail, Yahoo or Facebook account? No registration required!
Log in with Google account | Log in with Yahoo account | Log in with Facebook account
No account? Register here.