Created attachment 194138 [details] sample ODS with basic bar-of-pie showing the last 3 values grouped as sub-chart The new bar-of-pie and pie-of-pie chart types groups the last three values of the data range to construct the sub-chart (see bug 50934 comment 21). Note that this also differs from MS 365's default, which groups the last two. The UI does not currently allow changing how many values are grouped, or which ones. This is confusing (the user can't easily understand the logic) and is too limiting in customisability. Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 658a212585c56540a17c41111e6829716d4ef4e3 CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: CL threaded Copying UX/Design team for opinion on the best UI for that.
Made a suggestion on bug 161093 that might solve this ticket too.
FWIW, it appears to me that the default MSO behaviour (split type "auto") puts the last ceil(n/3.0) entries in the right subchart.
Kurt's pending patch on gerrit: https://gerrit.libreoffice.org/c/core/+/168690 Marking as "assigned".
WIP, removing UX.
Kurt Nordback committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/37bca7e571b1356b29addeb631066350e03e64ea tdf#161090 - Spec how many / which values are in remainder of-Pie chart It will be available in 25.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Thanks Kurt! Fix verified in own build with today's sources: Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: d671bceed0ba7195eae1e063d4a363074f8483a0 CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: CL threaded