How to Reorder Data Labels in PowerPoint

To analyze and visualize the data more effectively, you often need to display the data in some logical order. For example, let's assume you have researched the preference of TV channels by different age groups and want to see the results in ascending or descending order. Sorting is the most common method to reorder the data labels in a preferred way and make the charts legible for the report.

As label reordering is quite challenging in MS PowerPoint, Chartrics provides researchers with an integrated sorting tool smoothly working on raw and calculated data. With Chartrics add-in, you can quickly sort the data on PowerPoint charts using the integrated chart-making tool.

There are several ways to sort the data on PowerPoint charts:

  • Sort variable categories in ascending or descending order
  • Sort by another variable category in ascending or descending order
  • Sort by data source order in ascending or descending order
  • Manual sort

 

Sort by Another Variable Category in Ascending or Descending order

Method

  1. Right-click the variable on the Row or Column shelf > select Sort
  2. In the Sort dialog box, select Sort by Variable Category option > choose Acceding or Descending order > choose variable > choose category > click Apply

 

Sort by Data Source Order in Ascending or Descending order

Method

  1. Right-click the variable on the Row or Column shelf > select Sort
  2. In the Sort dialog box, select Sort by Variable Category option > choose Acceding or Descending order

 

Manual Sort

Method

  1. Right-click the variable on the Row or Column shelf > select Sort
  2. In the Sort dialog box, select Sort by Manual option > choose Acceding or Descending order > select the category and move it to the desired position

Automatically update all your PowerPoint charts with the new data in 15 seconds.