You can change the order, placement, and worksheet orientation of data series in a chart.
Plot data series from worksheet rows or columns
When the range of values for different data series in a 2-D chart varies widely, or when you have mixed types of data (such as price and volume), you can plot one or more data series on a secondary value (y) axis. The scale of the secondary axis reflects the values for the associated series.
Reverse the plotting order of categories, values, or series
You can reverse the plotting order of categories or values for most charts, as well as of data series for 3-D charts with a third axis. You cannot reverse the plotting order of values in a radar chart.
For values, select the Values in reverse order check box.
For series in 3-D charts, select the Series in reverse order check box.
Control the way empty cells are plotted in a chart
Change the points plotted in a pie-of-pie or bar-of-pie chart
You can also change which slices appear in the pie-of-pie or bar-of-pie chart by dragging. Click a slice or bar segment on the main chart, and then drag it to the pie-of-pie or bar-of-pie chart, or vice versa.
Change the plotting order of data series
To change the plotting order of data series in a surface chart, click a legend key.