Excel 2007 : Line Charts

The workbook is really huge with many many pages, Ive not really started a section on my teams league and attendance progress, I keep attempting but failing to make the line chart, so I keep putting it off. Ive coppied a page in a new book what I manage to do last night with the data concerned shown in other types of charts but I'd like the line chart as Ive explained in the post above.
I know its going to be too long to run from 1925-2009, I intend doing it in say blocks of 10-15 years.