[Solved] Add data points to chart in spreadsheet

Discuss the spreadsheet application

[Solved] Add data points to chart in spreadsheet

Postby legalnan » Sun Apr 11, 2021 10:23 pm

I have a chart on my spreadsheet but can't remember how to add data points - all my data is in column A. I've entered several more rows to column a and wish to add the data from those rows to my chart. any help much appreciated
Last edited by Hagar Delest on Fri Apr 16, 2021 8:57 pm, edited 1 time in total.
Reason: tagged solved.
Open Office 4.1.6 on Windows 10
legalnan
 
Posts: 16
Joined: Tue Jul 07, 2020 8:10 pm

Re: chart in spreadsheet

Postby Villeroy » Sun Apr 11, 2021 11:08 pm

Insert new cells or entire rows before you enter the new values into the newly inserted cells.

1) Select the values you have appended without insertion.
2) Insert new rows or cells.
3) Move the values into the new cells.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 29591
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: chart in spreadsheet

Postby legalnan » Mon Apr 12, 2021 5:43 am

Thank you so much but I lost my chart after trying to do it myself. I now have a new spreadsheet with data in columns A and B. Can you please tell me how to make a line chart? Column A is the data and column B is the date of each data point. I'm not really worried about the dates, so if it would be easier to just use column A that would be fine. You can't make the instruction too simple. I've been spending hours with no success. Any help much appreciated.
Open Office 4.1.6 on Windows 10
legalnan
 
Posts: 16
Joined: Tue Jul 07, 2020 8:10 pm

Re: Chart in spreadsheet

Postby Hagar Delest » Mon Apr 12, 2021 7:53 am

See if that helps: Creating a chart.

Please add [Solved] at the beginning of the title in your first post (top of the topic) with the *EDIT button if your issue has been fixed.
LibreOffice 7.0.5 on Xubuntu 21.04 and 7.0.5 portable on Windows 10

Off-line, back on 16-May
User avatar
Hagar Delest
Moderator
 
Posts: 29677
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Chart in spreadsheet

Postby legalnan » Tue Apr 13, 2021 5:40 am

So I highlighted column A and inserted chart and picked line chart. The line is very very thick. to make it thinner I have to stretch out the chart's width much too much to ever print. Also I'd like my chart to go from 165 to 135. but it continues down to 120 with 130-120 being empty. And at the bottom is the row numbers which I don't need. Is there a way to make the line thinner? Is there a way to eliminate 130-120? Is there a way to remove the row numbers from the bottom? And what does "calc" mean? And which axis is x and which is Y. I'm assuming one is vertical and one horizontal? Thanks very much for answers to any of these questions
Open Office 4.1.6 on Windows 10
legalnan
 
Posts: 16
Joined: Tue Jul 07, 2020 8:10 pm

Re: Chart in spreadsheet

Postby robleyd » Tue Apr 13, 2021 5:54 am

The answers to most of your questions will probably be found in the links on the right of the page Hagar linked above, viz:
Editing charts
Formatting charts
Formatting 3D charts
Formatting chart elements

Calc is the name of the spreadsheet application in Apache OpenOffice.

math.net wrote:The x-axis and y-axis are axes in the Cartesian coordinate system. Together, they form a coordinate plane. The x-axis is usually the horizontal axis, while the y-axis is the vertical axis.
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.4.6.2 (SlackBuild for 6.4.6 by Eric Hameleers) - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3882
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Add data points to chart in spreadsheet

Postby legalnan » Fri Apr 16, 2021 6:32 am

I'm getting there but can't make sense of the instructions. I thought I'd try uploading the spreadsheet - That chart starts on T4. I would like the x axis range to go from 165 to 135 only. I would like to remove the row numbers under the chart, and I would like to print chart only. Any help would be amazing.
Attachments
chart data 2.ods
(80.56 KiB) Downloaded 13 times
Open Office 4.1.6 on Windows 10
legalnan
 
Posts: 16
Joined: Tue Jul 07, 2020 8:10 pm

Re: Add data points to chart in spreadsheet

Postby Villeroy » Fri Apr 16, 2021 2:53 pm

chart data 3.ods
(46.2 KiB) Downloaded 18 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 29591
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Add data points to chart in spreadsheet

Postby legalnan » Fri Apr 16, 2021 8:12 pm

All issues solved!!!! Thanks ever so much.
Open Office 4.1.6 on Windows 10
legalnan
 
Posts: 16
Joined: Tue Jul 07, 2020 8:10 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 20 guests