On 04/01/2019 14.08, Dave Howorth 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 use LO when I need a chart, but long ago I used other tools. Maybe I wrote my own about 1992. There is a gnu chart or graph tool somewhere, I don't remember the exact name. gnuplot Graphing scientific data has a problem compared to "business" use, that we want both X and Y data proportional on both axis, and this is not the default in LO. You could upload a sample file and we can try to have a go. Or mail it to me, as you prefer.
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.
That's a complicated layout. I think you should have one column of timestamps and another of temperatures. One column for each sensor, humidity, more temps, whatever.
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.
I suppose the demands of the software are high now, yes. -- Cheers / Saludos, Carlos E. R. (from openSUSE 15.0 (Legolas))