I need a simple chart but.....

Discuss the spreadsheet application
Post Reply
blakemulder
Posts: 5
Joined: Mon Jul 27, 2020 10:08 pm

I need a simple chart but.....

Post by blakemulder »

I need a simple chart from my data. The data is current in amps and the labels will be the time the reading was taken. In order to get good resolution on the chart I have a high sample rate of 1000 data points. I cant obviously display 1000 labels they just look a mess. Can I just put in a time for every 20th sample or something like that? Please, if you can keep this simple as im struggling just to get a chart at all! Thankyou for your kind help
Last edited by floris v on Fri Nov 22, 2024 6:55 pm, edited 1 time in total.
Reason: Enabled signature
OPENOFFICE 4.17
WIN 10
User avatar
Lupp
Volunteer
Posts: 3620
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: I need a simple chart but.....

Post by Lupp »

Please complete your forum profile with a signature telling other users what branch (AOO or LibO) and what version(s) you are using.

Please attach an example of what you have to your question.

What are "amps"?
Last edited by Lupp on Fri Nov 22, 2024 4:43 pm, edited 1 time in total.
On Windows 10: LibreOffice 24.8.3 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
Alex1
Volunteer
Posts: 793
Joined: Fri Feb 26, 2010 1:00 pm
Location: Netherlands

Re: I need a simple chart but.....

Post by Alex1 »

I suppose ampères.
AOO 4.1.15 & LO 24.8.3 on Windows 10
FJCC
Moderator
Posts: 9457
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: I need a simple chart but.....

Post by FJCC »

If your "labels" are times, they should be numbers, though possibly formatted as time-of-day, and you should make an XY (Scatter) plot, not a Line plot. Calc will automatically format the axes of a scatter plot to place tick marks at reasonable intervals. If you have trouble getting a scatter plot to work, please upload an example of your Calc file. To upload a file, click Post Reply and look for the Attachments tab just below the box where you type a response.

Lupp - "amps" is short for amperes, the SI unit of electric current.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
User avatar
Lupp
Volunteer
Posts: 3620
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: I need a simple chart but.....

Post by Lupp »

I also supposed "amps" was meant to mean some A (Ampère), and the labels should show the time.
However, there are standards.
aoo112167_ChartWithSpecialLabelling.ods
(96.9 KiB) Downloaded 8 times
The attached example was made with LibO V 24.8.3.
Older versions of LibO and any AOO/OO.o will not be able to interpret/show every detail the way it was designed.
On Windows 10: LibreOffice 24.8.3 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
Post Reply