On Fri, 4 Jan 2019 13:08:01 +0000 Dave Howorth <dave@howorth.org.uk> wrote:
I just made a chart of some data in LibreOffice Calc and was disappointed both by the process (very slow) and by the results (apparent lack of ability to modify the view).
I've used spreadsheets sporadically over the years to make calculations but wouldn't call myself an expert and I can't remember the last time I tried to make a chart. So I know nothing.
I'm wondering if I've missed something in LO that would help me have a better experience with this chart, or if there are better tools to use to draw charts from spreadsheet data.
I asked on the LO list but only got one reply that only addressed one small issue, so I suppose there is no solution in LO. I thought I'd ask here to see what other software there is that can draw line charts, ideally from .ods data, and ideally with a GUI to set up the chart. But I can export the data in some other format and I can write config files to drive the layout if necessary.
I'm running Version 6.1.3.2 of LibreOffice (actually the openSUSE build for Leap 15.0). I'm running a machine with an i5-4460 CPU @ 3.20GHz and 8 GB main memory. It's normally fast enough for whatever I want to do.
My spreadsheet data is in columns. Hourly samples of temperature and humidity. Column A is dates and column B is the times of day. I've also created column C that adds A+B to get a single value. Then ten columns of humidity data and eleven columns of temperature data. There are currently just over 5000 rows of samples.
Making the chart was extremely slow. Every time I changed the Name of a line of the chart I had to wait whilst it cycled through several steps to make the change. Initially when I removed some empty columns from the data range, it took an age to do so. etc.
Now I've created the chart and got some reasonable lines across it, but what I hope are the dates and times along the X axis are just a mess and I've no idea how to make them display usefully.
I haven't found any way to select individual points on the chart to display the detailed value of that point or all the values at that time (a cursor). Nor do I see a way to temporarily hide individual data lines to more clearly see other particular lines, for example.
If there's any way to do these things with an LO chart, and to speed it up, I'd be grateful for any pointers. Or if there are better options out there that can read .ods or .csv and display charts, that would be very interesting. Google just wants to tell me about a lot of diagramming tools.
TIA, Dave
Thanks one and all. I got a little more help on the libreoffice list that got it to work as well as I think its going to. My current plan is to import the data into my emoncms system and use its graphing tool, which is fairly flexible. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org