How to create a line graph in Excel 2010

[pie-eater]

Hello,

I haven't posted for a while, so any assistance will be hugely appreciated.

I have placed bets on 7 teams in Europe and want to plot their positions after every match to show a detailed line graph.

The Y-Axis shows the position in the table, ie. 1 - 20

I want the X-Axis to plot positions for each team per each date.

I hope I am making sense!

I have attached the data that I am using to create my line graph.

Thanks for taking the time to assist...much appreciated.

[Andy Pope]

Simplest approach is to use a pivot table/chart.
You will need to update the data range used for the pivot table but this can be done using a dynamic named range.