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

Discuss the spreadsheet application

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

Postby CLC » Thu Jul 04, 2019 12:46 pm

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
CLC
 
Posts: 3
Joined: Thu Jul 04, 2019 12:33 pm

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

Postby MrProgrammer » Mon Jul 08, 2019 5:14 pm

 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 269 times
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: 3870
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

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

Postby gerard24 » Mon Jul 08, 2019 5:52 pm

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.2.8 on Windows 10
gerard24
Volunteer
 
Posts: 950
Joined: Sat Oct 30, 2010 5:12 pm
Location: France

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

Postby CLC » Thu Jul 18, 2019 3:19 pm

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
CLC
 
Posts: 3
Joined: Thu Jul 04, 2019 12:33 pm

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

Postby Zizi64 » Thu Jul 18, 2019 3:53 pm

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; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.3.2; AOO4.1.6
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: 8473
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

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

Postby CLC » Thu Jul 18, 2019 4:05 pm

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
CLC
 
Posts: 3
Joined: Thu Jul 04, 2019 12:33 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 18 guests