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).
Slow? How much data are we talking about?
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 the chart facilities of LO quite a lot, I have not found anything that match. I quite like the charting ability of rrdtool though. I have occasionally gone to look for tools I could use in batch-mode, e.g. from a Makefile. Haven't found much sofar.
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.
Sounds like rrdtool would be an alternative worth investigating.
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 don't recall having tried with that amount of data - seems like a lot to want to put into one chart?
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).
I think you get that if you hover over a data point. -- Per Jessen, Zürich (0.4°C) http://www.hostsuisse.com/ - virtual servers, made in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org