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.