Page tree
Skip to end of metadata
Go to start of metadata

There are several ways to sort data in a chart:

  • Sort by size
  • Toggle between ascending or descending alphabetic or numeric order
  • Sort by TopN

To sort values in a chart by size

  1. From the Toolbox, select Workbooks, then select a workbook and worksheet. 
  2. Select the Design workspace icon if needed. 
  3. Right-click one of the values in the chart and choose Quick Sort.
  4. To toggle between ascending and descending order, right-click and choose Quick Sort again.

You can also sort by dimensions or measures.

To sort data within an axis

  1. From the Toolbox, select Workbooks, then select a workbook and worksheet. 
  2. Select the Design workspace icon if needed. 
  3. Click the X-axis or Y-axis list and right-click a measure or dimension to see the Sort command.
  4. Click Sort.
  5. Choose the sort direction: ascending or descending.
  6. Choose to sort alphabetically, within hierarchy, or by measure. If you choose Measure, select a measure from the list.
  7. Click Sort.

To sort a dimension in detail

  1. From the Toolbox, choose Workbooks, then select a workbook and worksheet that use details such as a scatter chart, wordmap, or treemap. 
  2. Select the Design workspace icon if needed. 
  3. Right-click the dimension and choose Sort or TopN.
  4. When you choose Sort, choose to sort alphabetically, within hierarchy, or by measure.
    If you choose Measure, select a measure from the list.
    1. Choose the sort direction: ascending or descending.
    2. Click Sort.
  5. When you choose TopN, create your condition.
    1. Choose is in the top or bottom.
    2. Specify the number of top or bottom values.
    3. Click Apply.

See Filter by top or bottom values for details on using TopN.

  • No labels