Reordering the Display of a Data Series Microsoft Excel - Excel Tips
Jun 25, 2016. When you create a chart in Excel, you may have a need to change the order in which the data series are displayed in the chart. One way to do. By default, Microsoft Office Excel determines the minimum and maximum. To reverse the order of the values, select the Values in reverse order check box. Applies To Excel 2010 Word 2010 Outlook 2010 PowerPoint 2010 Excel. To reverse the order of categories, select the Categories in reverse order check box.
Change the scale of the horizontal category axis in a chart - Office.
You have two options. If your original data is always sorted but you want to show it the other. 'Categories in reverse order'; 'Horizontal axis crosses at maximum category'. This looks a bit different version to version but is consistently the. Jul 30, 2015. If you want to reverse the order of curves in a waterfall plot, you can do the following. Now you will see the reversed curves in the graph.
Make bar charts in original order of data for improved readability.
Aug 10, 2015. When you “show categories in reverse order”, Excel also moves the horizontal axis to top of the chart. If you want to show it at bottom, you can. Aug 16, 2014. When charting your data, a legend is always a nice finishing touch. In Excel, this order is tied to the order in which your data series are plotted.