topic Reorder categories in a column chart in ArcGIS Insights Questions

Reorder categories in a column chart

AileenProfir — Mon, 11 Mar 2019 21:00:25 GMT

I'm wondering if you can sort categories in a column chart in any other way than alphabetical/ascending/descending.

I would rather not add the extra 0 on the income category for it to show up in order from smallest to greatest (see attached photo).

Re: Reorder categories in a column chart

LindaBeale — Mon, 13 Jul 2020 17:04:22 GMT

Unfortunately at the moment there are no other options than those that you see in "Sort" on the card. We are hoping to introduce additional methods in the future.

Re: Reorder categories in a column chart

Elizabeth_Burniston — Thu, 25 Apr 2024 15:44:30 GMT

@LindaBeale Has there been any progress on this? I too, am unable to sort on the card in any way other than described above. Can there not be a drag/drop - custom order option? Illustrating a chart with the name of weekdays in random order is rather confusing to the end user.

Re: Reorder categories in a column chart

LindaBeale — Thu, 25 Apr 2024 21:58:17 GMT

Hi Elizabeth,

Thanks for checking in on this.

For column and bar charts, it is possible to manually re-order. The option can be found under sort:

Having selected sort manually, you can drag a column or bar to the order you would like. Press Apply on exit of manually sorting.

If you have temporal fields, all date/time components are automatically ordered correctly. You can convert string fields to time (e.g. if the formatting has been lost in a csv file), by clicking on the icon of the field:

You will the see the date/time components in the correct order in all charts.

I hope that helps.

Re: Reorder categories in a column chart

Elizabeth_Burniston — Thu, 25 Apr 2024 22:49:26 GMT

@LindaBeale Converting the string field to time corrected the order just as I had wanted! Thank you so much for your quick, and most helpful, response!