When creating a pivot table I do a lot of charts. Every time the table gets refreshed and the rows/columns change, the charts get messed up.
It would be really nice, if a chart could be automatically generated instead of the table. Functionality would be similar to the table generatiopn but data is displayed in a bar, line or XY chart.
I'm surprised that I can not find duplicate for request for Pivotchart
MS Office feature>
Please note that enhancements are largely tackled by volunteers. The NEW status confirms that this is a valid enhancement but does not guarantee that the feature will be implemented in the near future (or at all in fact). If a volunteer finds this to be interesting, they'll assign it to themselves and try to implement it.
That being said - this is a pretty awesome request :)
Nantes Métropole is funding development of this feature in the community version.
Pivot charts will be released in LibreOffice 5.4: https://tomazvajngerl.blogspot.de/2017/03/pivot-charts-in-libreoffice-part-1.html
Tomaž Vajngerl committed a patch related to this issue.
It has been pushed to "master":
tdf#83257 [API-CHANGE] Pivot chart implementation
It will be available in 5.4.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Demands of users are very different. For me not having Pivot Chart in Calc was great benefit in comparison to Excel. Is it possible to switch off this function at some point?