Rearranging data series While working with series in charts, Excel creates a default order in which the series would appear, depending on the structure of the selection. You can change the underlying structure or else manually format the chart. To manually affect the changes, carry out the following steps:
o Select the data, and go to the "Insert" tab.
o Create a chart as per your requirement.
o Right-click anywhere inside the chart.
o In the context menu, select the "Select Data ..... option.
o In the "Select Data Source" dialog box, click on the series you want to move.
o With the help of the Up and Down Arrow buttons, move the series to the desired position.
o Click "OK" to save.
Reply With Quote
Copyright Techfuels
Bookmarks