Skip to Main Content
Status Future consideration
Categories Reports
Created by Phil Warden
Created on Mar 25, 2021

Sort options in charts

Currently, charts are sorted in alpha/numeric order along the X axis. I would like to sort the data based upon the cell value from high to low so that group Z with the highest value is listed on the far left or right side of the chart, then the rest in ascending or descending order.

  • Attach files
  • Khaoula Atmani
    Feb 28, 2024

    This feature would greatly enhance the clarity of numerous charts. In my scenario, I oversee multiple projects simultaneously, each project progressing through various states such as "1. Exploration," "2. Design," "3. ...," "4. ...," "5. Operation," etc. I aim to visualize this progression using scatter charts due to the large number of projects. Currently, I have project names plotted along the X-axis and project statuses along the Y-axis. However, the scatter chart loses its effectiveness when the Y-axis is not sorted, as it becomes challenging to interpret the progression of projects.

  • Zach Novak
    Oct 31, 2022

    There is a workaround for this problem. If you go to the pivot view> edit data, and change teh 'Within cells list as:' field to a count, you can then sort the columns by 'Cells (Total of counted records)'. Once you do this to the pivot, you can then go back to your bar chart and it will be sorted in ascending/descending order.

    1 reply
  • Andries van Heerden
    Jul 13, 2022

    This would help a lot for planning purposes!!

  • Alia Connor
    Apr 14, 2021

    Similarly, I'd like to be able to control the sort of chart's X-axis. In my case, not from cell value, but would love to be able to drag/drop to sort them how I see fit.

  • +1

Control sort of slices in pie charts

Right now, pie charts always sort by the size of the slices. I'd love to be able to sort the slices by the text of the Series or some other value. That way, week to week I can show the change in size of the pie slices to my team. I'm trying to vis...
Leigh B almost 3 years ago in Reports 0 Future consideration