Sort data in a chart

You can sort category and series data in a chart that is based on a PivotTable list, database table, or query.

1. Do one of the following:
   • If you want to sort numerical data in a series, click the series or a series point within the series.
   • If you want to sort items in a field alphabetically, click the category or series field, or click a category axis label or legend entry.
2. Do one of the following:
   • Click Sort Ascending or Sort Descending on the toolbar.
   • If you have a stacked bar, stacked area, or stacked column chart, and you want to sort numerically based on the height of the entire stacked value rather than just one series, right-click the series or point, point to Sort, and then click Ascending By Total or Descending By Total.