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
Please attach an example file, which does not yet contain the chart and give exact steps on creating the chart.
Dear flywire, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Sample data and steps were provided in the report.
(In reply to flywire from comment #3) > Sample data and steps were provided in the report. I don't see an example file.
Created attachment 172446 [details] Demonstrates can't change Pivot Pie Chart Show Room data series to Used.
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
[Automated Action] NeedInfo-To-Unconfirmed
(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
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
*** Bug 164533 has been marked as a duplicate of this bug. ***
(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.