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/

/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

------------------------------------------------------------------------------
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