[Solved] X-Y scatter chart lines disappeared

Discuss the spreadsheet application
Post Reply
alanack
Posts: 90
Joined: Tue Jan 27, 2009 7:54 pm

[Solved] X-Y scatter chart lines disappeared

Post by alanack »

Windows 10, LibreOffice 7.4.3.2(64)

I've had a X-Y scatter chart I've used for years, on which I am continually adding and deleting data. For some reason the lines (one in positive numbers, one in negative) that average the data points have disappeared. I simply can't figure out how to get in there and add that those lines back. Thanks for your help!
Last edited by RoryOF on Sun Dec 11, 2022 6:29 pm, edited 2 times in total.
Reason: Added green tick [RoryOF, Moderator]
OOo 4.1.2 on Windows 7
User avatar
Hagar Delest
Moderator
Posts: 33693
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: X-Y scatter chart lines disappeared

Post by Hagar Delest »

Can you upload the file?
LibreOffice 25.2 on Linux Mint Debian Edition (LMDE 7 Gigi) and 25.2 portable on Windows 11.
alanack
Posts: 90
Joined: Tue Jan 27, 2009 7:54 pm

Re: X-Y scatter chart lines disappeared

Post by alanack »

Hi Hagar. I'm trying to attach the file here. Hope it works. Thanks!
YM DAILY HIGHS & LOWS.ods
(36.57 KiB) Downloaded 103 times
OOo 4.1.2 on Windows 7
erbsenzahl
Volunteer
Posts: 270
Joined: Tue Apr 18, 2017 8:23 am
Location: Germany

Re: X-Y scatter chart lines disappeared

Post by erbsenzahl »

alanack wrote: Sat Dec 10, 2022 10:00 pmthe lines (one in positive numbers, one in negative) that average the data points have disappeared. I simply can't figure out how to get in there and add that those lines back.
Hi,
I checked your file on LO 7.4.3.2 and 7.3.7.2 and AOO 4.1.13 (on LinuxMint).
In each case the average lines (mean value lines) have not been defined (and thus did not exist).
To add these lines double click on diagram (edit mode) → select one data series → right hand click → Insert mean value line

After saving, closing and reopening the file the mean value lines still existed. ;)
HTH
 
 
YM DAILY HIGHS & LOWS_MeanValueLines.ods
(47.35 KiB) Downloaded 75 times
LibreOffice current versions 24.x/25.x/26.x and OpenOffice 4.1.16
on LinuxMint 21 - 23 Mate, W10-64 pro
alanack
Posts: 90
Joined: Tue Jan 27, 2009 7:54 pm

Re: X-Y scatter chart lines disappeared

Post by alanack »

Thanks for your help with this, erbsenzahl, I was able to return the lines, no problem!
OOo 4.1.2 on Windows 7
Post Reply