Sorting in numerical order

Understand how different items are ranked by sorting the data from the lowest number to the highest or from the highest number to the lowest. For example, you want to see the profit margin for each product line from the least profitable to the most profitable.

Procedure

  1. Touch and hold, or right-click, the axis label of the column that you want to sort.
    You can sort the data in either the x-axis or y-axis, depending on what type of data is in an axis.
  2. Click the Sort icon.
    Sort icon
  3. Select how you want to sort the data:
    • Sort ascending
    • Sort descending
  4. To return to the default sort order, select Auto (none).