For the excel file attached, I want to adjust the chart table (table that is part of the chart) so that the series "GOAL CAR" is moved up in the table until it is just below "CAR GREEN".
I know that usually this is just a matter of opening the "SELECT DATA..." from the right pop-up menu that appears when right mouse clicking the end of the chart. Then, in the Legend Entries (series) list, select the series "GOAL CAR" and use the ^ v buttons to move up/down to the desired position.
However, this does not seem to be working.
The chart/table is somewhat complex, because there are some series that are type "stack column", "clustered column" & "line".
When I make all the series the same type, say "stack column" then moving the series up works just fine. But as soon as I update an individual series chart type to either "line" or "clustered column" (not all series the same type), excel automatically bumps it to the bottom where I don't want it.
I am working with Win7/Office2010/Excel2010, but have also tried Office2013/Excel2013 with same results.
Any idea how to move the series "GOAL CAR" up in the table, while keeping it a series type of "line" and the other series in the same order while keeping in there existing series plot type, as shown in the attachment?