Importing graphs from Excel
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.
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
On 04/14/2013 03:36 AM, Jurgen Gaeremyn wrote:
Hello list,
for an article I need to edit a graph made in Excel (2007).
This is my current workflow:
- In Excel: Print to PDF (using Cute PDF)
- 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.
Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis & visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter _______________________________________________ Inkscape-user mailing list Inkscape-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/inkscape-user
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.
participants (3)
-
Alex Mandel
-
darkweasel
-
Jurgen Gaeremyn