Bug 116601 - XY-Scatter PivotChart uses row numbers instead of (time) values
Summary: XY-Scatter PivotChart uses row numbers instead of (time) values
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
5.4.6.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 125750 (view as bug list)
Depends on:
Blocks: Pivot-Chart XY-Scatter-Chart
  Show dependency tree / graph
 
Reported: 2018-03-24 09:36 UTC by Philippe Hemmel
Modified: 2024-10-16 08:24 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Attachments
example spreadsheet (33.30 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-03-24 09:36 UTC, Philippe Hemmel 		Details
pivot chart dates scaling (38.30 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-03-19 13:27 UTC, ouinouin 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Philippe Hemmel 2018-03-24 09:36:30 UTC 
Created attachment 140849 [details]
example spreadsheet

## Steps to reproduce

* create a table with 2 columns. The first column contains dates, its header is called "date""
* create a pivot table with the "date" column as row field, the second column as a column field
* create a pivot chart based on the pivot table, chart type "Line"

See the example document : web_error.ods

## Actual behaviour

* With a chart type Line, it's impossible to specify that the chart is time based (the X axis)
* With a chart type XY, the X axis shows numbers and not dates, and the numbers are related to the line number of each values in the pivot table

See the  sheet called "Table dynamique_php_error_1"

## Expected behaviour

The behavior must be the same as a normal chart based on a normal table (not a pivot table) containing the same values (see sheet3 in the attached document)

* With a chart type Line, I should be able to specify that the chart is time based (the X axis). 
	* the check box "time based" is in the second step of the chart wizard, "Data range", which is inactive for a pivot chart
* With a chart type XY, the X axis should show dates and should be time based

It's a kind of a regression, because before the pivot chart function, I was able to create a normal chart based on a pivot table that could have the expected behaviour. Obviously the chart was not linked to the pivot table, but it was easy to adapt.
It's more complicated now, as I have to copy all the data in another sheet to create the right chart.

## Desktop configuration

**Operating system:** Linux 4.13 (Kubuntu 17.10 Artful 64 bits)

Plasma 5.12.3 (kubuntu-ppa/backports)

**LibreOffice version:** 

Version: 5.4.6.2
Build ID: 1:5.4.6~rc2-0ubuntu0.17.10.1
CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: kde4; 
Locale: fr-FR (fr_FR.UTF-8); Calc: single

Coming from http://ppa.launchpad.net/libreoffice/libreoffice-5-4/ubuntu
Comment 1 raal 2018-03-26 06:05:43 UTC 
Confirm. X axis is type Numeric.
Version: 6.1.0.0.alpha0+
Build ID: 1fbe46cf08f525e78016feef83f4c38b79b337ba
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2018-03-24_23:04:38
Comment 2 no where 2018-05-26 16:09:03 UTC 
I have the same issue.

I think a more general solution should allow any data type that can be mapped to numeric range to be the value for an x/y-chart based on a pivot table.

What are the plans to implement this feature?
Comment 3 QA Administrators 2019-05-27 02:45:45 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2021-05-27 05:01:31 UTC Comment hidden (obsolete)
Comment 5 ouinouin 2022-03-19 13:27:10 UTC 
Created attachment 178969 [details]
pivot chart dates scaling

left graph on tab 3 frome pivot chart, right one ame data copied and made with a normal chert, observe differences between both and see hos the date range is affected by pivot chart.
Comment 6 ouinouin 2022-03-19 13:29:30 UTC 
hi, this behavior is stille present on libreoffice at least 7.1.
the initial issue is that on the pivot chart, the dates are taken element by element on the x scale, the range isnt correctly calculated for dates
if there is non contiguous dates, they will be displayed as if they were contiguous, this is a very annoying bug, since combined with the fact you cannot make directly anymore a normal chart from cells of a pivot table, it makes creation of a Time based graph difficult.
Comment 7 QA Administrators 2024-03-19 03:12:45 UTC Comment hidden (obsolete)
Comment 8 Regina Henschel 2024-09-15 23:28:05 UTC 
There is still true XY chart in Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 976567aee323afd09629b6adf13537908f43d2a8
CPU threads: 32; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: threaded
Comment 9 Regina Henschel 2024-09-15 23:32:33 UTC 
There is still _no_ true XY chart
Comment 10 Regina Henschel 2024-09-16 09:28:43 UTC 
*** Bug 125750 has been marked as a duplicate of this bug. ***