[Solved] Create chart with baseline and data readings

Discuss the spreadsheet application

[Solved] Create chart with baseline and data readings

Postby TiaVali » Sun Feb 09, 2020 9:48 pm

I'm new to OpenOffice Calc (and fairly new to spreadsheet creating, in general). I created a graph with a line connecting points on the graph. My first three points are baseline readings. The rest of the points are post-treatment readings. ** I need to remove ONE SEGMENT of the line connecting the points. I ALSO need to insert a vertical line separating my baseline readings and my post-treatment readings. ** I cannot find how to do this. I have searched all kinds of videos on YouTube and done a Google search. Can anyone please help me find information on how I can do what I need to do?

UPDATE - I found where it tells me to double click on the cell and the single click where I want the line to break and then press CTRL+ENTER, but it's removing TWO segments (and also a point that I DON'T want removed).
Attachments
Homework Graph 1.ods
I need to create a line break between points 3 and 4, without removing any of the points.
(16.03 KiB) Downloaded 16 times
Last edited by MrProgrammer on Tue Mar 10, 2020 4:52 pm, edited 6 times in total.
Reason: Tagged ✓ [Solved]; Changed subject, was: New to Calc, Can't figure this out...
OpenOffice 4.1.5
TiaVali
 
Posts: 4
Joined: Sun Feb 09, 2020 9:44 pm

Re: New toCalc, Can't figure this out...

Postby Zizi64 » Sun Feb 09, 2020 9:55 pm

Please upload your ODF type sample file here.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9548
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: New toCalc, Can't figure this out...

Postby TiaVali » Sun Feb 09, 2020 10:08 pm

Zizi64 wrote:Please upload your ODF type sample file here.


What is that?
OpenOffice 4.1.5
TiaVali
 
Posts: 4
Joined: Sun Feb 09, 2020 9:44 pm

Re: New toCalc, Can't figure this out...

Postby RoryOF » Sun Feb 09, 2020 10:10 pm

ODF is the generic term for OpenOffice/LibreOffice native formats.
Apache OpenOffice 4.1.7 on Xubuntu 20.04.1 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31447
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: New toCalc, Can't figure this out...

Postby TiaVali » Sun Feb 09, 2020 10:12 pm

RoryOF wrote:ODF is the generic term for OpenOffice/LibreOffice native formats.


I'm sorry but I still have no idea what this means.
OpenOffice 4.1.5
TiaVali
 
Posts: 4
Joined: Sun Feb 09, 2020 9:44 pm

Re: New toCalc, Can't figure this out...

Postby RoryOF » Sun Feb 09, 2020 10:14 pm

What type of file are you using? Upload a sample file that shows the problem.
Apache OpenOffice 4.1.7 on Xubuntu 20.04.1 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31447
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: New to Calc, Can't figure this out...

Postby robleyd » Mon Feb 10, 2020 12:24 am

[Forum] How to attach a document here Note maximum file size is 128K. If your file is larger, use a file sharing site such as Mediafire and post the link here. The link also contains information on how to anonymise your document if it contains confidential information.
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3463
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: New to Calc, Can't figure this out...

Postby MrProgrammer » Mon Feb 10, 2020 12:56 am

Hi, and welcome to the forum.

RoryOF wrote:ODF is the generic term for OpenOffice/LibreOffice native formats.
TiaVali wrote:I'm sorry but I still have no idea what this means.
We wanted you to attach your spreadsheet, and the document itself, not a picture of it, which is often worthless. You've done that now; thank you. To learn more about the term "ODF" go to OpenOffice Help → Index → Search term → ODF file formats.

TiaVali wrote:I'm new to OpenOffice Calc (and fairly new to spreadsheet creating, in general)
Read [Tutorial] Ten concepts that every Calc user should know. Column A in your attachment does not contain dates; it contains text. (Toggle View → Value Highlighting.) You will want these values to be dates.

TiaVali wrote:I created a graph with a line connecting points on the graph.
No, you created a chart with Insert → Chart. Knowing the correct terms helps you find solutions in the forum.

TiaVali wrote:My first three points are baseline readings. The rest of the points are post-treatment readings. ** I need to remove ONE SEGMENT of the line connecting the points. I ALSO need to insert a vertical line separating my baseline readings and my post-treatment readings.
It's possible to create a vertical separator line, however the approach in my attachment visually separates the data and will be simpler for you. I have put dates in column A and used an XY (Scatter) chart.
202002091642.ods
(19.09 KiB) Downloaded 16 times

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3964
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Create chart with baseline and data readings

Postby TiaVali » Mon Feb 10, 2020 4:44 am

Thank you so much, @MrProgrammer!

Great info to start me off :-)
OpenOffice 4.1.5
TiaVali
 
Posts: 4
Joined: Sun Feb 09, 2020 9:44 pm

Re: Create chart with baseline and data readings

Postby jrkrideau » Mon Feb 10, 2020 2:44 pm

Note that Mr. P has changed the date column from text to dates which makes much more sense.
LibreOffice 6.4.3.2; Ubuntu 20.04
jrkrideau
Volunteer
 
Posts: 3788
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada


Return to Calc

Who is online

Users browsing this forum: No registered users and 12 guests