[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [libreoffice-users] what's the best way to make charts of spreadsheet data

On 4-1-2019 18:54, Regina Henschel wrote:
Hi Dave,

Dave Howorth schrieb am 02-Jan-19 um 18:12:

My spreadsheet data is in columns. Column A is the dates and column B
is the times. 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.

Each data item produces an object, which is selectable in edit mode of the chart. Your data produce 5000*(10+11)=105000 objects. That cannot be fast.

What is the purpose of the chart? You do not need 105000 objects to illustrate something.

With 5000 items in x-direction a lot of them will be on top of others. My screen has only 1920 dots width and yours?

The fact that a screen has only (a limited) number of pixels, has NOTHING to do with how many items are used, or can be used,  in a graph.

Maybe the user has a A0-plotter to print this graph?

This should still be possible with software like LibreOffice, or the should kill the option to create graph's....

just 2 cents

To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.