How to sort bars of a pivot chart in ascending or descending order. attached is an example of a sheet containing 2 columns “Name” and “Value”. While creating the pivot table or if I go to table properties the I double click on (Name) in the row field then choose options. the “Sort by” menu showed “Name” and doesn’t allow me to to change that to “Sum 0f Value” (please see attached image.
Dbl-click chart
Dbl-click x-axis
On first tab: “Reverse direction”
hello Villeroy, thanks for suggestion. However, this only changes the order of "Names) (instead of W, X,Y, Z) to (Z, Y, X then W) but doesn’t rearrange the bars according to their value
Please see the attached image. I wonder if I can rearrange the bars so that the smallest value (in this example Y=16) comes first , followed by X =20 then W =24 and lastly Z which is 36. For example, in Excel, right click on the bars gives a Sorting menu for data series where you are able to arrange in ascending or descending according to their value.
Sorted_By_Value.ods (19.1 KB)
Open that dialog with the sort options.
Choose “Manual”
Sort by: Sum(Value)
Choose “Descending”
Confirm dialogs
Yes, I think this is broken.
For when there are number values in the Row fields.
Paste the resulting table, sort and create the chart from there.
EDIT: After following @Villeroy steps (more carefully), I arrived to the desired result. Confirm that here could be a bug.
Version: 7.4.7.2 (x86) / LibreOffice Community
Build ID: 723314e595e8007d3cf785c16538505a1c878ca5
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: es-MX (es_MX); UI: en-US
Calc: threaded
Same in:
Version: 7.6.0.2 (x86) / LibreOffice Community
Build ID: 41d6f628ba3f046f16b5fa9fa8db8d4c2ab3b582
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: es-MX (es_MX); UI: en-US
Calc: threaded
Nope. In the same dialog you can sort by data fields.
