Have you ever done a chart and wished you could change the order of your data? Here's how.
The exercise and the result are in the Chart Series file.
Here is the chart with the data shown in the data table section.
The order goes East, South, Midwest, West. What if we want to change it to West, South, MIdwest, East.
To begin, we would click on a bar. Click on one of the West bars.
Up in the formula bar, you will see the formula for the West chart series:
=SERIES(Sales!$A$5,Sales!$B$1:$E$1,Sales!$B$5:$E$5,4)
This tells where the data comes for the header, x axis and y axis. In addition, the last argument is the order of the series. In this case, it is series number 4, the last one.
We want to change it to be the first series shown. Click on the formula bar and change the series number to 1.
=SERIES(Sales!$A$5,Sales!$B$1:$E$1,Sales!$B$5:$E$5,1)
Continue on until you have the chart in the order you want.
To recap, to change the order of the items in your chart, rather than changing the underlying worksheet with the data, simply change the series order right in the chart: