To change the order of the data in either the Category axis - the x-axis - or the Value axis - the y-axis - double-click on the axis to open the Format Axis dialog box. Click the 'Axis Options' button and then the check box for 'Values in Reverse Order.' Right-clicking on any chart element shows an option to format it in the shortcut menu. Sometimes you need to showcase different data on the x-axis than Category.
Perhaps you wish to plot the Legend information on the Category axis or vice versa. To swap the chart's Legend entries and Category axis, go to the Design menu under Chart Tools and click the 'Switch Row/Column' button in the Data grouping. Excel 2013 includes on-object buttons that appear to the right of any chart when it is active.
These buttons provide quick access to common chart customization features.
Oct 29, 2015 Since the release of Excel 2016 for Mac, customers have given great feedback about its ease of use and the benefits of the new features. We want to highlight the Excel 2016 for Mac features that customers rave about and share some tips and tricks that could save you a ton of time using the most powerful spreadsheet and data analysis tool on the Mac platform.
Closed as off-topic by, Dec 20 '18 at 16:26 This question appears to be off-topic. The users who voted to close gave these specific reasons:. 'Questions about general computing hardware and software are off-topic for Stack Overflow unless they directly involve tools used primarily for programming. You may be able to get help on.' – TylerH, jww, Matthieu Brucher. 'Questions seeking debugging help (' why isn't this code working?' ) must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself.
Questions without a clear problem statement are not useful to other readers. – M-M, grizzthedj If this question can be reworded to fit the rules in the, please. To change the stacking order for series in charts under Excel for Mac 2011:. select the chart,. select the series (easiest under RibbonChart LayoutCurrent Selection),. click Chart LayoutFormat Selection or MenuFormatData Series,. on popup menu Format Data Series click Order, then click individual series and click Move Up or Move Down buttons to adjust the stacking order on the Axis for the subject series.
This changes the order for the plot and for the legend, but may not change the order number in the Series formula. I had a three series plot on the secondary axis, and the series I wanted on top was stuck on the bottom in defiance of the Move Up and Move Down buttons. It happened to be formatted as markers only. I inserted a line, and presto(!), I could change its order in the plot. Later I could remove the line and sometimes it could still be ordered, but sometimes not.
Excel 2010 - if you're looking to reorder the series on a pivot chart:. go to your underlying pivot table. right-click on one of the Column Labels for the series you're looking to adjust (Note: you need to click on one of the series headings (i.e. 'Saturday' or 'Sunday' in the example shown below) not the 'Column Labels' text itself). in the pop-up menu, hover over 'Move' and then select an option from the resulting sub-menu to reposition the series variable.
your pivot chart will update itself accordingly. This function gets the series names, puts them into an array, sorts the array and based on that defines the plotting order which will give the desired output. Function IncreasingLegendSort(mychart As Chart) Dim Arr ReDim Arr(1 To mychart.FullSeriesCollection.Count) 'Assigning Series names to an array For i = LBound(Arr) To UBound(Arr) Arr(i) = mychart.FullSeriesCollection(i).Name Next i 'Bubble-Sort (Sort the array in increasing order) For r1 = LBound(Arr) To UBound(Arr) rval = Arr(r1) For r2 = LBound(Arr) To UBound(Arr) If Arr(r2) rval Then 'Change ' to '.