Excel 2007 : Line Charts

Im getting really confused on how to create a specific line chart. Ive had several go's over the weeks but just cant do it. It's probably something easy or cant be done.
I want the horizontal axis to display years say: 1925, 1926, 1927 and so on.
I want the vertical axis to display a division/league say: division 1, division 2, division 3 and so on.
Now what I want the line to do is show the progress of a single team and show which division that year. For example if it was in division 3 in 1925 and the team got promoted the line would move to division two. Hope someone can help were Im going wrong.
Ive managed to do line charts showing attendances over the years probably because excel puts a number in the vertical axis.