Monday, September 26, 2011

How to Change an Excel Chart to Ascending Order


1. Click on the column heading. This is Column A, B, C, etc, in a basic worksheet or the Table in a PivotTable report. Again, you must change the chart data in order to change the chart. Chart data can originate from a basic or PivotTable form.
2. Click the arrow Filter drop-down on Column heading or Column Labels. Again, a column label is the Column heading in a PivotTable.
3. Click the arrow Filter drop-down. In PivotTables, the Axis Fields are categories and the Legend Fields are Series.
4. Change the Excel Chart data to Ascending order by clicking 'Sort A to Z' for text, 'Sort Smallest to Largest' for numbers and 'Sort Oldest to Newest' for dates and times.

Blogger news