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:
: 164533 (view as bug list)
Depends on:
Blocks: Pivot-Chart
  Show dependency treegraph
 
Reported: 2020-04-10 05:19 UTC by flywire
Modified: 2025-01-01 17:42 UTC (History)
4 users (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

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
Comment 9 gmolleda 2024-12-31 17:29:34 UTC
I think that a pivot chart should be able to be inserted regardless of whether a pivot table exists. That's why I have created a proposal for improvement: https://bugs.documentfoundation.org/show_bug.cgi?id=164533
Comment 10 flywire 2025-01-01 02:38:48 UTC
*** Bug 164533 has been marked as a duplicate of this bug. ***
Comment 11 flywire 2025-01-01 04:43:30 UTC
(In reply to gmolleda from bug 164533 comment #0)
> To create a business dashboard I need to insert pivot charts without any
> associated pivot tables. It would be nicer if filters could be external and
> linked to multiple pivot charts at once.

Nice use case description.