League position change trend chart, how?

[Guest]

hi all, great board by the way.

i'm running a fantasy football league, and i wanted to know how to make a
certain type of chart through 'chart wizard' - the chart will show the trend
of position change of the duration of the compition, for example, it would
show how team A has moved up and down by position over the weeks, ie one week
they were 2nd, next 3rd etc etc.

hope i've been clear enough for you to understand

 

[Fred Smith]

You need to create a table which ranks each team by position each week. For the
table, you'll want columns like Week, Team, (Wins, Losses, Ties, Points),
Position. For Position, use the Rank function.

Then chart the position for each team by week.