Under Chart Tools, on the Design tab, in the Data group, click Select Data. Top of page Change the plotting order of data series in a chartĬlick the chart for which you want to change the plotting order of data series. In the Axis Options category, under Axis Options, select the Series in reverse order check box. On a chart, click the depth axis, or do the following to select it from a list of chart elements: You can change the plotting order of data series so that large 3-D data markers do not block smaller ones.įigure: 3-D charts with data series that are displayed in reversed order

Top of page Reverse the plotting order of data series in a 3-D chart Note: You can't reverse the plotting order of values in a radar chart. In the Axis Options category, do one of the following:įor categories, select the Categories in reverse order check box.įor values, select the Values in reverse order check box. On the Format tab, in the Current Selection group, click Format Selection. Under Chart Tools, on the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click the chart element that you want to use. You can also do the following to select the axis that you want from a list of chart elements:Ĭlick a chart. To change the plotting order of values, click the vertical (value) axis.

To change the plotting order of categories, click the horizontal (category) axis. Reverse the plotting order of data series in a 3-D chartĬhange the plotting order of data series in a chart Reverse the plotting order of categories or values in a chart You can also change the order in which the individual data series are plotted in a chart. Additionally, in 3-D charts that have a depth axis, you can reverse the plotting order of data series so that large 3-D data markers do not block smaller ones. If the chart for which you want to change the plotting order displays axes, you can quickly reverse the order in which the categories or values are plotted along those axes.

Histogram excel