Bug 98543 - Improve chart wizard when passing categories column to XY (scatter) chart
Summary: Improve chart wizard when passing categories column to XY (scatter) chart
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
: 126149 (view as bug list)
Depends on:
Blocks: Chart-Wizard 132308
  Show dependency treegraph
Reported: 2016-03-09 09:12 UTC by Milan Bouchet-Valat
Modified: 2022-11-27 17:46 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Test ODS document (8.19 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-03-09 09:12 UTC, Milan Bouchet-Valat

Note You need to log in before you can comment on or make changes to this bug.
Description Milan Bouchet-Valat 2016-03-09 09:12:04 UTC
Created attachment 123422 [details]
Test ODS document

The chart wizard behaves strangely when trying to pass a column containing categories for an XY (scatter) chart. Let me illustrate this with the attached file.

* If you select only columns B and C (including their headings) and create an XY chart using the chart wizard, you get a correct result: X is used for the X axis, Y for the Y axis. Fine

* Now, if you select the whole table (columns A, B, and C), column A is correctly detected as representing the categories. But now X and Y are considered as two different series with only Y-axis values, and no X-axis values. This behaviour is exactly what you get if you create a Line chart. But I argue that this does not make much sense for an XY (scatter) chart: the very nature of this type of chart is to represent both X and Y.

The most logical result would be to create a single data series with X for X-axis, Y for Y-axis, and column A for categories. Then, categories should be added as data labels by default (since you specified them, it means you want to use them).
Comment 1 m_a_riosv 2016-03-09 09:39:35 UTC
Hi @Milan, I'm agree, specially selecting XY chart and no numerical values in the first column.
Comment 2 Regina Henschel 2017-03-02 17:06:04 UTC
The errorwas introduced between OOo3.2.1 and OOo3.4.1.
Comment 3 raal 2019-07-14 17:21:23 UTC
*** Bug 126149 has been marked as a duplicate of this bug. ***
Comment 4 raal 2019-07-14 17:23:39 UTC
(In reply to Regina Henschel from comment #2)
> The errorwas introduced between OOo3.2.1 and OOo3.4.1.

then it's not an enhancement, but a bug.
Comment 5 QA Administrators 2022-04-22 04:02:20 UTC Comment hidden (obsolete)
Comment 6 Peter Gervai 2022-11-27 17:46:44 UTC
This bug exists in 
Version: / LibreOffice Community
Build ID: 40(Build:3)
CPU threads: 8; OS: Linux 6.0; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF8); UI: en-US
Debian package version: 1:7.4.2-3
Calc: threaded