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 treegraph
 
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:
Regression By:


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

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