Bug 161090

Summary:	Allow specifying how many / which values are grouped in remainder of Pie-of-Pie or Bar-of-Pie chart
Product:	LibreOffice	Reporter:	Stéphane Guillou (stragu) <stephane.guillou>
Component:	Chart	Assignee:	kurt.nordback <kurt.nordback>
Status:	ASSIGNED ---
Severity:	normal	CC:	dionemaddern, heiko.tietze, kurt.nordback
Priority:	medium
Version:	24.8.0.0 alpha0+
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=50934 https://bugs.documentfoundation.org/show_bug.cgi?id=161220 https://bugs.documentfoundation.org/show_bug.cgi?id=161229 https://bugs.documentfoundation.org/show_bug.cgi?id=161800
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	90486
Attachments:	sample ODS with basic bar-of-pie showing the last 3 values grouped as sub-chart

Description Stéphane Guillou (stragu) 2024-05-16 00:32:46 UTC

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.

Comment 1 Heiko Tietze 2024-06-07 07:15:33 UTC

Made a suggestion on bug 161093 that might solve this ticket too.

Comment 2 kurt.nordback@protonmail.com 2024-06-11 22:54:02 UTC

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.

Comment 3 Stéphane Guillou (stragu) 2024-06-27 11:00:14 UTC

Kurt's pending patch on gerrit: https://gerrit.libreoffice.org/c/core/+/168690

Marking as "assigned".

Comment 4 Heiko Tietze 2024-07-01 10:50:29 UTC Comment hidden (off-topic)

WIP, removing UX.