Bug 132016 - Pivot Chart Select Data Range Selection
Summary: Pivot Chart Select Data Range Selection
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
6.4.1.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Chart
  Show dependency tree / graph
 
Reported: 2020-04-10 05:19 UTC by flywire
Modified: 2021-05-31 05:12 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Demonstrates can't change Pivot Pie Chart Show Room data series to Used. (28.89 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-05-30 01:03 UTC, flywire 		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 flywire 2020-04-10 05:19:56 UTC 
Description:
"The data range and the data series pages of the chart wizard are not enabled. They are controlled by the pivot table."

I understand a pivot chart is created from the first column of numbers in the pivot table. It would be useful to select data column/row to be charted similar to non-pivot chart functionality.

Steps to Reproduce:
It is not possible to produce a Pie chart of item by Weight if the following pivot table is displayed.

Sample data:
Item	Volume 	Weight
Alpha	4	3
Gamma	16	8
Beta	54	2

Actual Results:
Pie chart with Item by Volume

Expected Results:
Pie chart with Volume by weight


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Refer description
Comment 1 Buovjaga 2020-08-23 15:57:40 UTC 
Please attach an example file, which does not yet contain the chart and give exact steps on creating the chart.
Comment 2 QA Administrators 2021-02-20 04:06:10 UTC Comment hidden (obsolete)
Comment 3 flywire 2021-02-20 23:59:17 UTC 
Sample data and steps were provided in the report.
Comment 4 Buovjaga 2021-02-21 06:33:34 UTC 
(In reply to flywire from comment #3)
> Sample data and steps were provided in the report.

I don't see an example file.
Comment 5 flywire 2021-05-30 01:03:52 UTC 
Created attachment 172446 [details]
Demonstrates can't change Pivot Pie Chart Show Room data series to Used.
Comment 6 flywire 2021-05-30 01:19:14 UTC 
Long been a problem of not being able to select other than first pivot table column for pie chart. Complex workaround: https://stackoverflow.com/questions/30125663/excel-pie-charts-from-pivot-table-columns
Comment 7 QA Administrators 2021-05-30 04:14:12 UTC Comment hidden (obsolete)
Comment 8 Buovjaga 2021-05-31 05:12:18 UTC 
(In reply to flywire from comment #5)
> Created attachment 172446 [details]
> Demonstrates can't change Pivot Pie Chart Show Room data series to Used.

To reproduce:

1. Click inside the pivot table that you want to present in your chart.

2. Choose Insert – Chart or click in the Insert Chart Icon Insert Chart icon in the main toolbar.

LibreOffice Calc automatically detects the pivot table and opens the pivot chart wizard.

https://help.libreoffice.org/latest/en-US/text/scalc/guide/pivotchart_create.html?DbPAR=CALC#bm_id531525141739769