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. In the design window, make sure the chart is activated. For instructions, see Help for your design program.
2. 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.
3. 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.