Create a SVG chart from Excel/Libreoffice Calc data sheet?
Hello.
I work for a free and non commercial bicycle magazin and we often publish scientific articles. They contain data sheets and charts.
Until know we publish the charts as a PNG.
The quality is low and as every bitmap graphic it doesn't scale well.
Is there a tool which allows to create a chart from an Excel (or Libreoffice Calc) data sheet as an SVG?
Of course the code of the SVG should be of high quality. Text should be text. Basic shapes (circles, rectangles, etc.) shouldn't be realised as a path etc.
Thanks.
Andreas
Hi Andreas,
The best method I know of is:
* Convert the spreadsheet to a pdf using libreoffice * Convert the pdf to svg using inkscape
Both of these actions can be scripted from the command line.
Does this make sense?
Best Regards, Martin Owens
On Thu, 2016-02-25 at 18:38 +0100, Andreas Borutta wrote:
Hello.
I work for a free and non commercial bicycle magazin and we often publish scientific articles. They contain data sheets and charts.
Until know we publish the charts as a PNG.
The quality is low and as every bitmap graphic it doesn't scale well.
Is there a tool which allows to create a chart from an Excel (or Libreoffice Calc) data sheet as an SVG?
Of course the code of the SVG should be of high quality. Text should be text. Basic shapes (circles, rectangles, etc.) shouldn't be realised as a path etc.
Thanks.
Andreas
Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 _______________________________________________ Inkscape-user mailing list Inkscape-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/inkscape-user
Martin Owens schrieb:
The best method I know of is:
- Convert the spreadsheet to a pdf using libreoffice
- Convert the pdf to svg using inkscape
That means, that you have to configure all features of the chart in libreoffice, do I understand it correctly?
I thought of a tool which allows to configure the features of the chart and after that the chart will be created directly to a high quality SVG.
It is hard to believe, that the path over Libreoffice and a PDF as a bitmap and than an import to inkscape could result in good code.
But may be I'm wrong.
Does anybody has an example of a spreadsheet and a SVG?
Of course the goal "high quality SVG" is not an abstract one.
Only good code allows to manipulate the parameters of the SVG effectively, when you want to change the appearance.
Sorry, when I'm sceptical about the suggested way.
Best, Andreas
On Fri, 2016-02-26 at 01:04 +0100, Andreas Borutta wrote:
Of course the goal "high quality SVG" is not an abstract one.
Only good code allows to manipulate the parameters of the SVG effectively, when you want to change the appearance.
Sorry, when I'm sceptical about the suggested way.
You may be right about the considered option compared to other's suggestions. But the output for pdf will not be rather, it'll be vector and you'll get a good visual which looks like the visuals found in office.
Martin Owens
Martin Owens schrieb:
On Fri, 2016-02-26 at 01:04 +0100, Andreas Borutta wrote:
Of course the goal "high quality SVG" is not an abstract one.
Only good code allows to manipulate the parameters of the SVG effectively, when you want to change the appearance.
Sorry, when I'm sceptical about the suggested way.
You may be right about the considered option compared to other's suggestions. But the output for pdf will not be rather, it'll be vector and you'll get a good visual which looks like the visuals found in office.
I tried it.
Source of a simple spreadsheet with a chart: http://www.ooowiki.de/DiagrammMitLinien.html
I took one spreadsheet out of it: http://borumat.de/+svg/tabellendokument.ods
I exported it from Libreoffice as a PDF: http://borumat.de/+svg/tabellendokument.pdf
I imported the PDF into Inkscape: http://borumat.de/+svg/tabellendokument.svg
The SVG code of the chart is not editable/usable, because it uses only "svg:path". And it is full of redundances.
I'm not a programmer, but I think that only a specialized software/plugin can create high quality (editable) SVG code from spreadsheet data.
All the concepts of charts has to be "mapped":
axis, grid, scale, legend, ...
Semantically useful IDs has to be used and so on ...
Best, Andreas
Andreas, I have not tried it, but Google sheets might be a path to a quality solution. https://developers.google.com/chart/interactive/docs/
/d
On 26 February 2016 at 09:24, Andreas Borutta <borumat@...26...> wrote:
Martin Owens schrieb:
On Fri, 2016-02-26 at 01:04 +0100, Andreas Borutta wrote:
Of course the goal "high quality SVG" is not an abstract one.
Only good code allows to manipulate the parameters of the SVG effectively, when you want to change the appearance.
Sorry, when I'm sceptical about the suggested way.
You may be right about the considered option compared to other's suggestions. But the output for pdf will not be rather, it'll be vector and you'll get a good visual which looks like the visuals found in office.
I tried it.
Source of a simple spreadsheet with a chart: http://www.ooowiki.de/DiagrammMitLinien.html
I took one spreadsheet out of it: http://borumat.de/+svg/tabellendokument.ods
I exported it from Libreoffice as a PDF: http://borumat.de/+svg/tabellendokument.pdf
I imported the PDF into Inkscape: http://borumat.de/+svg/tabellendokument.svg
The SVG code of the chart is not editable/usable, because it uses only "svg:path". And it is full of redundances.
I'm not a programmer, but I think that only a specialized software/plugin can create high quality (editable) SVG code from spreadsheet data.
All the concepts of charts has to be "mapped":
axis, grid, scale, legend, ...
Semantically useful IDs has to be used and so on ...
Best, Andreas
Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 _______________________________________________ Inkscape-user mailing list Inkscape-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/inkscape-user
Donn Ingle schrieb:
I have not tried it, but Google sheets might be a path to a quality solution. https://developers.google.com/chart/interactive/docs/
Thanks for your hint. But that is Javascript and not a SVG.
And you can't use an excel spreadsheet or a csv file. All the data has to be transformed in special javascript data code.
Kind regards, Andreas
I was thinking of the output to PNG : https://developers.google.com/chart/interactive/docs/printing Also, the spreadsheet angle: https://developers.google.com/chart/interactive/docs/spreadsheets
Anyway, I agree - a nice SVG solution would be best. /d
On 26 February 2016 at 11:35, Andreas Borutta <borumat@...26...> wrote:
Donn Ingle schrieb:
I have not tried it, but Google sheets might be a path to a quality solution. https://developers.google.com/chart/interactive/docs/
Thanks for your hint. But that is Javascript and not a SVG.
And you can't use an excel spreadsheet or a csv file. All the data has to be transformed in special javascript data code.
Kind regards, Andreas
Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 _______________________________________________ Inkscape-user mailing list Inkscape-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/inkscape-user
On Fri, Feb 26, 2016 at 2:35 AM, Andreas Borutta <borumat@...26...> wrote:
Donn Ingle schrieb:
I have not tried it, but Google sheets might be a path to a quality solution. https://developers.google.com/chart/interactive/docs/
Thanks for your hint. But that is Javascript and not a SVG.
Actually, it is both! "Charts are rendered using HTML5/SVG technology to provide cross-browser compatibility (including VML for older IE versions) and cross platform portability to iPhones, iPads and Android." Unfortunately it uses paths instead of circles/ellipses or rectangles. Other than that it is somewhat semantic, though, even supporting ARIA (accessibility, which is a field that is basically all about [semantic] markup and device-independent parsing thereof).
And you can't use an Excel spreadsheet or a CSV file. All the data has to be transformed in special JavaScript data code.
As Don Ingle replied, data can come from a Google Spreadsheet (through "Datasource Queries https://developers.google.com/chart/interactive/docs/datatables_dataviews#query") and Google Sheets can import from Excel, Calc, or CSV/TSV, so that is a possible toolchain. But you are right that it is not a very pleasant solution.
The file Maren Hachmann attached seems the cleanest (especially if you use Scrub, which is the 'Save as > Simplified SVG' option in Inkscape), as it uses the appropriate SVG primitives.
-Arlo James Barnes
Having frequent need to create publication grade graphs from raw data I find the most reliable workflow to be :
Plot the data using gnuplot or gnu octave (or more recently Veusz - an excellent addition to the FOSS library) These programs can all accept a variety of input files - .csv, ascii etc and export to a broad spectrum of graphic formats including of course .svg. R also has amazing graphics capabilities but may involve a longer, steeper learning curve.
I then typically import the svg to Inkscape to pretty it up. It must be said though, that Veusz eliminates the need for much of what formerly was done in this step.
There are are horses for courses ........ Pick the best one for your needs. It's unlikely to involve LibreOffice or Excel.
Stu
On Feb 26, 2016, at 3:26 AM, Donn Ingle <donn.ingle@...155...> wrote:
Andreas, I have not tried it, but Google sheets might be a path to a quality solution. https://developers.google.com/chart/interactive/docs/ https://developers.google.com/chart/interactive/docs/
/d
On 26 February 2016 at 09:24, Andreas Borutta <borumat@...26... mailto:borumat@...26...> wrote: Martin Owens schrieb:
On Fri, 2016-02-26 at 01:04 +0100, Andreas Borutta wrote:
Of course the goal "high quality SVG" is not an abstract one.
Only good code allows to manipulate the parameters of the SVG effectively, when you want to change the appearance.
Sorry, when I'm sceptical about the suggested way.
You may be right about the considered option compared to other's suggestions. But the output for pdf will not be rather, it'll be vector and you'll get a good visual which looks like the visuals found in office.
I tried it.
Source of a simple spreadsheet with a chart: http://www.ooowiki.de/DiagrammMitLinien.html http://www.ooowiki.de/DiagrammMitLinien.html
I took one spreadsheet out of it: http://borumat.de/+svg/tabellendokument.ods http://borumat.de/+svg/tabellendokument.ods
I exported it from Libreoffice as a PDF: http://borumat.de/+svg/tabellendokument.pdf http://borumat.de/+svg/tabellendokument.pdf
I imported the PDF into Inkscape: http://borumat.de/+svg/tabellendokument.svg http://borumat.de/+svg/tabellendokument.svg
The SVG code of the chart is not editable/usable, because it uses only "svg:path". And it is full of redundances.
I'm not a programmer, but I think that only a specialized software/plugin can create high quality (editable) SVG code from spreadsheet data.
All the concepts of charts has to be "mapped":
axis, grid, scale, legend, ...
Semantically useful IDs has to be used and so on ...
Best, Andreas
Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 _______________________________________________ Inkscape-user mailing list Inkscape-user@lists.sourceforge.net mailto:Inkscape-user@...1841...ge.net https://lists.sourceforge.net/lists/listinfo/inkscape-user https://lists.sourceforge.net/lists/listinfo/inkscape-user
Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140________... Inkscape-user mailing list Inkscape-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/inkscape-user
Stuart Edwards schrieb:
[...] (or more recently Veusz - an excellent addition to the FOSS library)
[...] I then typically import the svg to Inkscape to pretty it up. It must be said though, that Veusz eliminates the need for much of what formerly was done in this step.
Sounds very interesting! Thanks a lot for that hint!
Do you like to show us a SVB file/code, which has been created by Veusz?
Kind regards, Andreas
Andreas Borutta schrieb:
Do you like to show us a SVB file/code, which has been created by Veusz?
I would also love to see, as an ideal example, a SVG which has been "hand crafted" for a simple spreadsheet like that: http://borumat.de/+svg/tabellendokument.ods
May be I'm wrong with my thoughts, that a SVG without "path" but only with "text", "line", "rect" and "polyline" is possible? And with "speaking" semantic ids (from the column or row headers). Free of redundant code.
That would be great, if someone has ever seen such an ideal SVG of a chart and likes to share. As an inspiration.
Kind regards, Andreas
Not sure that I fully understand your objective - but here's a csv file that contains ~3000 lines of data in 3 columns. Veusz plots the third column against the square root of the first. I then export the graphic from Veusz as an svg with editable text - also attached. The csv is 57KB and the svg is 186KB - so quite efficient. Opens in Inkscape without complaint for further tweaking if needed, and in any text editor for inspection of the code.
The attached vsz file is only 1KB but must be in the same directory as the csv.
If you need further assistance, probably should move the discussion off this board as it's no longer an Inkscape issue.
HTH
Stu
On Feb 26, 2016, at 10:39 AM, Andreas Borutta <borumat@...26...> wrote:
Stuart Edwards schrieb:
[...] (or more recently Veusz - an excellent addition to the FOSS library)
[...] I then typically import the svg to Inkscape to pretty it up. It must be said though, that Veusz eliminates the need for much of what formerly was done in this step.
Sounds very interesting! Thanks a lot for that hint!
Do you like to show us a SVB file/code, which has been created by Veusz?
Kind regards, Andreas
Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 _______________________________________________ Inkscape-user mailing list Inkscape-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/inkscape-user
Stuart Edwards schrieb:
Not sure that I fully understand your objective - but here's a csv file that contains ~3000 lines of data in 3 columns. Veusz plots the third column against the square root of the first. I then export the graphic from Veusz as an svg with editable text - also attached. The csv is 57KB and the svg is 186KB - so quite efficient. Opens in Inkscape without complaint for further tweaking if needed, and in any text editor for inspection of the code.
Thanks for you test and the attached files.
I looked at the SVG code. It is not what I'm thinking of.
Veusz uses the element "path" instead of the appropriate elements "line" and "polyline".
Further the code is full of redundant code.
E.G.: Styles are not declared centralized but decentralized.
The attached vsz file is only 1KB but must be in the same directory as the csv.
If you need further assistance, probably should move the discussion off this board as it's no longer an Inkscape issue.
Yes, I agree.
Kind regards, Andreas
If you really want to use LibreOffice - and it is a fine package with a lot of capability - it appears that you may be able to do what you need.
I opened your 'tabellendokument' in LO by double clicking and I get a spreadsheet with embedded graph showing temperature against month for a series of four years. If I select the graph (single click) and then right click on it, the drop down menu includes 'export as image'. Select it and one of the format options will be 'SVG - StarDraw 2.0'. Select it and hit 'save'. The resulting svg file opens in Inkscape and the text is editable as text and all other features appear to be editable too. (see attached)
What else do you need?
(Note this was accomplished using OS X 10.10, and LO 4.4.5.2 - things may differ on other platforms or versions)
Stu
On Feb 26, 2016, at 2:24 AM, Andreas Borutta <borumat@...26...> wrote:
Martin Owens schrieb:
On Fri, 2016-02-26 at 01:04 +0100, Andreas Borutta wrote:
Of course the goal "high quality SVG" is not an abstract one.
Only good code allows to manipulate the parameters of the SVG effectively, when you want to change the appearance.
Sorry, when I'm sceptical about the suggested way.
You may be right about the considered option compared to other's suggestions. But the output for pdf will not be rather, it'll be vector and you'll get a good visual which looks like the visuals found in office.
I tried it.
Source of a simple spreadsheet with a chart: http://www.ooowiki.de/DiagrammMitLinien.html
I took one spreadsheet out of it: http://borumat.de/+svg/tabellendokument.ods
I exported it from Libreoffice as a PDF: http://borumat.de/+svg/tabellendokument.pdf
I imported the PDF into Inkscape: http://borumat.de/+svg/tabellendokument.svg
The SVG code of the chart is not editable/usable, because it uses only "svg:path". And it is full of redundances.
I'm not a programmer, but I think that only a specialized software/plugin can create high quality (editable) SVG code from spreadsheet data.
All the concepts of charts has to be "mapped":
axis, grid, scale, legend, ...
Semantically useful IDs has to be used and so on ...
Best, Andreas
Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 _______________________________________________ Inkscape-user mailing list Inkscape-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/inkscape-user
Stuart Edwards schrieb:
If you really want to use LibreOffice - and it is a fine package with a lot of capability - it appears that you may be able to do what you need.
I opened your 'tabellendokument' in LO by double clicking and I get a spreadsheet with embedded graph showing temperature against month for a series of four years. If I select the graph (single click) and then right click on it, the drop down menu includes 'export as image'. Select it and one of the format options will be 'SVG - StarDraw 2.0'. Select it and hit 'save'. The resulting svg file opens in Inkscape and the text is editable as text and all other features appear to be editable too. (see attached)
Thanks for that test, Stuart.
But the SVG code of the attached file is not what I'm thinking of.
It uses the path element insted of the appropriate elements like "line" or "polyline".
The code of svgtest.svg is a very good example to show how code for a simple chart of simple data should /not/ be.
Kind regards, Andreas
Am 25.02.2016 um 18:38 schrieb Andreas Borutta:
Hello.
I work for a free and non commercial bicycle magazin and we often publish scientific articles. They contain data sheets and charts.
Until know we publish the charts as a PNG.
The quality is low and as every bitmap graphic it doesn't scale well.
Is there a tool which allows to create a chart from an Excel (or Libreoffice Calc) data sheet as an SVG?
Of course the code of the SVG should be of high quality. Text should be text. Basic shapes (circles, rectangles, etc.) shouldn't be realised as a path etc.
Thanks.
Andreas
- There is an extension that creates pie charts and bar charts for Inkscape (I've fixed it, the original version didn't work with 0.91 any more).
Find it here:
https://github.com/Moini/NiceCharts/tree/patch-1
You need to export as CSV file from Excel, then load the file into the extension.
It produces arcs and rectangles and text. Maybe that is what you need?
Kind regards, Maren
Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 _______________________________________________ Inkscape-user mailing list Inkscape-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/inkscape-user
On Thu, 2016-02-25 at 22:14 +0100, Maren Hachmann wrote:
You need to export as CSV file from Excel, then load the file into the extension.
It produces arcs and rectangles and text. Maybe that is what you need?
It sounds like a nice extension to add to our default extensions, it depends on simplestyle (not sure what that is) but the rest seems clean.
Martin,
On 02/25/2016 01:19 PM, Martin Owens wrote:
On Thu, 2016-02-25 at 22:14 +0100, Maren Hachmann wrote:
You need to export as CSV file from Excel, then load the file into the extension.
It produces arcs and rectangles and text. Maybe that is what you need?
It sounds like a nice extension to add to our default extensions, it depends on simplestyle (not sure what that is) but the rest seems clean.
Martin,
I typically use R for this purpose. Python would also work. Extremely repeatable, and easy to make a minor fix if the data changes. Touchups in Inkscape are possible after export to SVG or PDF. Note if using R the ggplot2 package is the easiest way to export SVG plots.
Enjoy, Alex
Am 25.02.2016 um 22:19 schrieb Martin Owens:
On Thu, 2016-02-25 at 22:14 +0100, Maren Hachmann wrote:
You need to export as CSV file from Excel, then load the file into the extension.
It produces arcs and rectangles and text. Maybe that is what you need?
It sounds like a nice extension to add to our default extensions, it depends on simplestyle (not sure what that is) but the rest seems clean.
Martin,
simplestyle comes with Inkscape. It's one of those helper py modules in the extensions directory.
(http://bazaar.launchpad.net/~inkscape.dev/inkscape/trunk/view/head:/share/ex...)
I agree it would be useful for people to have that by default.
(Isn't your question more for the devel list or a bug report at lp?)
Maren
Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 _______________________________________________ Inkscape-user mailing list Inkscape-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/inkscape-user
Maren Hachmann wrote:
- There is an extension that creates pie charts and bar charts for
Inkscape (I've fixed it, the original version didn't work with 0.91 any more).
Find it here:
https://github.com/Moini/NiceCharts/tree/patch-1
You need to export as CSV file from Excel, then load the file into the extension.
Would you be so kind and create a testcase SVG for me with this extension? My knowledge about Inkscape is near zero, because I'm a complete beginner. Special techniques like installing an extension via phython scripts sounds complicated.
May be you like to use the data from http://borumat.de/+svg/tabellendokument.ods
Best, Andreas
Hallo Andreas,
Am 26.02.2016 um 08:50 schrieb Andreas Borutta:
https://github.com/Moini/NiceCharts/tree/patch-1
You need to export as CSV file from Excel, then load the file into the extension.
- Okay, I've tested the extension some more now, with the CSV file exported from your libreoffice file.
Turns out it has difficulties with UTF-8 (which I could fix in a hackish way ;P ) and it doesn't work correctly if the first line of the csv file isn't deleted (should be used as title instead, I think).
Also, it cannot parse the German , as a delimiter for float values, which is what libreoffice uses for me...
The results look nice as bar charts.
Would you be so kind and create a testcase SVG for me with this extension?
- Find it attached. I didn't save as optimized SVG now. The shadows are optional, and direction of the bars can be selected (they can also be stacked, or pie charts).
My knowledge about Inkscape is near zero, because I'm a complete beginner. Special techniques like installing an extension via phython scripts sounds complicated.
- Installing an Inkscape extension is as easy as unzipping it and then copying the files you get into the correct directory, which is listed in Edit -> Preferences -> System: User extensions.
Kind regards, Maren
Maren Hachmann schrieb:
https://github.com/Moini/NiceCharts/tree/patch-1
You need to export as CSV file from Excel, then load the file into the extension.
- Okay, I've tested the extension some more now, with the CSV file
exported from your libreoffice file.
Turns out it has difficulties with UTF-8 (which I could fix in a hackish way ;P ) and it doesn't work correctly if the first line of the csv file isn't deleted (should be used as title instead, I think).
Also, it cannot parse the German , as a delimiter for float values, which is what libreoffice uses for me...
The results look nice as bar charts.
Thanks a lot for testing it. The SVG code looks OK. Most important: no path element has been used by the extenstion.
Sure, it is full of redundant code, which is often typical for tools which do not implement concepts like "styles should be declared central" etc.
I will check out the other hints in this thread about the suggested workflows.
Kind regards, Andreas
On Thu, Feb 25, 2016, at 09:38 AM, Andreas Borutta wrote:
Hello.
I work for a free and non commercial bicycle magazin and we often publish scientific articles. They contain data sheets and charts.
Until know we publish the charts as a PNG.
The quality is low and as every bitmap graphic it doesn't scale well.
Is there a tool which allows to create a chart from an Excel (or Libreoffice Calc) data sheet as an SVG?
Of course the code of the SVG should be of high quality. Text should be text. Basic shapes (circles, rectangles, etc.) shouldn't be realised as a path etc.
A while back I worked with the Gnumeric team to ensure that users could just drag-n-drop a chart straight out of Gnumeric and directly into Inkscape. I haven't checked recently if that still works, but could be one option.
participants (8)
-
Alex M -
Andreas Borutta -
Arlo Barnes -
Donn Ingle -
Jon A. Cruz -
Maren Hachmann -
Martin Owens -
Stuart Edwards