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.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |