You’ll want to process these values visually. The people in charge naturally measure different throws here. Let’s assume you want to process the results of a throwing competition from a children’s sports day visually using a histogram. When you create this kind of chart, you can independently set the size of the bin. The size of a bin can be read from the width of the bar – and this is one of the advantages of a histogram. Here, both the width and the height of the bars play a role.

With the appropriate graphics, it’s possible to read how often certain values appear in one bin (a group of values). In the Select Data Source dialog box, in the Legend Entries (Series) box, click the data series that you want to change the order of.Ĭlick the Move Up or Move Down arrows to move the data series to the position that you want.Histograms represent the distribution of frequencies, which is why this kind of chart is mainly used in statistics. 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 graph excel