[Solved] X-axis not related to X values using scatter chart

Discuss the spreadsheet application
Post Reply
CLC
Posts: 3
Joined: Thu Jul 04, 2019 12:33 pm

[Solved] X-axis not related to X values using scatter chart

Post by CLC »

If I use X-Y scatter the x axe changes to even numbers not related to x values (like 0,2,4,6...), on line type I get the correct labels but also evenly spaced.
The pivot chart has tree columns, x y1 y2, values on the pivot chart are correct, but not shown on the graph.
Any idea?
Thanks in advance,
Carlos.
Last edited by CLC on Thu Jul 18, 2019 4:11 pm, edited 1 time in total.
LibreOffice 6 on Ubuntu 1804
User avatar
MrProgrammer
Moderator
Posts: 4895
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: X-axis not related to X values using XY (scatter) chart

Post by MrProgrammer »

 Edit: Split from [Solved] Chart: dates on the X-axis evenly distributed -- MrProgrammer 2019-07-08 10:11 
OpenOffice 3.0 has no pivot charts. Specify your actual installed version. Attach a document demonstrating the difficulty (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself).
Screen Shot 2019-07-08 at 10.04.32 .png
Screen Shot 2019-07-08 at 10.04.32 .png (14.31 KiB) Viewed 1433 times
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
gerard24
Volunteer
Posts: 958
Joined: Sat Oct 30, 2010 5:12 pm
Location: France

Re: X-axis not related to X values using XY (scatter) chart

Post by gerard24 »

If you try to make Pivot Chart, you may be using a recent version of LibreOffice.

LO cannot produce real X/Y from pivot table.
See https://bugs.documentfoundation.org/sho ... ?id=116601
and https://bugs.documentfoundation.org/sho ... ?id=125750
LibreOffice 6.4.5 on Windows 10
CLC
Posts: 3
Joined: Thu Jul 04, 2019 12:33 pm

Re: X-axis not related to X values using XY (scatter) chart

Post by CLC »

Thanks for your reply.
I apologise but, by mistake, I have ended up in this forum even if I was searching for libreOffice forum.
That is why the version was wrong.
Thanks again for your help.
Carlos.
LibreOffice 6 on Ubuntu 1804
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: X-axis not related to X values using XY (scatter) chart

Post by Zizi64 »

I have ended up in this forum even if I was searching for libreOffice forum.
You can ask questions related the LibreOffice on this forum, but we must know which software and what version are you using really. Otherwise we can not help you efficiently, or maybe we will suggest a workaround that non-relevant for your software.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
CLC
Posts: 3
Joined: Thu Jul 04, 2019 12:33 pm

Re: X-axis not related to X values using XY (scatter) chart

Post by CLC »

Hi Zizi64, thanks for the interest.
Here the LO about report:
Version: 6.0.7.3
Build ID: 1:6.0.7-0ubuntu0.18.04.8
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;
Locale: en-GB (en_US.UTF-8); Calc: group

I guess the problem is as reported in the links that Gerard24 posted. For what I have read there is a bug of LO.
If you think it is a way around it would be good for me to know.
The problem was very simple, as mentioned in my original post, I could not plot an XY scatter (from a pivot table) with the points of Y spaced as they should be, related the the real X and not to evenly spaced numbers.
Thanks for the information regarding posts of LO in this forum.
LibreOffice 6 on Ubuntu 1804
Post Reply