I am working on a excel program where I am doing a team ladder for positions after each round.
I have made a line chart to show how the team ladder positions change after each round.
The problem I have is 2 things, I would like the lines to match the background color of each team. The other problem is I would like the chart positions reversed, so 1 is up the top and 6 is on the bottom, but would also like to keep the rounds listed at the bottom.
The workbook is below
Bookmarks