On 01/04/2019 07:08 AM, Dave Howorth wrote:
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.
Dave, LO calc charting is on par with just about anything else. Performance is on par with Excel. The biggest problems I've found with both is they seem to be written by someone who came from the windows server coding world where it's good UI design to have to click through at least 5 nested dialogs accessed by clicking in non-intuitive place and activating secondary features by either a shift-click, or standing on one foot holding your left ear while whistling Dixie. If you post your data somewhere (or a subset), I'm happy to pull it in and play with it to see if anything shows up from a performance hit standpoint. For technical charting (and batch processing), there is always Gnuplot. It is a bit quirky with syntax, and good luck finding a concise howto that covers everything (apparently the demo should be enough for anyone -- not). But where it shines is batch processing and handling large data sets. You can easily use the language of your choice to process your data and then spit out as many differing charts as needed, directly to .pdf or .png, etc.. if you like. Let us know if you want a couple of compare and contrast experiences pulling your data in. I've always found just muddling through with the (LO Help in the past), now the woefully incomplete, but improving 'wiki' usually is enough to get me through the task. Check into the difference between using a calculated field and actual values as Gertjan suggested. I can see where that may cause chart generation fit continually checking whether a recalc is needed for every combined date and time. -- David C. Rankin, J.D.,P.E. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org