Steps to create a particular chart

Hey, Wondering if anyone can help me with this problem. I have a set of data and need to construct a plot of data, but i dont know the steps to create one in excel. i have an example of data and the correct chart but if anyone can provide me with the steps to create the chart in excel, i would appreciate it.Thanks

UK Household Final Consumption Expenditure on Housing

Year Q1 Q2 Q3 Q4
2002 311 295 292 315
2003 326 313 312 339
2004 353 336 331 360
2005 372 359 358 391
2006 411

You need to transform this data table in to a series of two columns:
Year-Period
Value

Then you can chart it.

To transform the table values:
Take the values (not the headings or row labels) and put them in a new worksheet starting in A1. .
Give the range a name eg data2
In cell A1 type:
=INDEX(data2,ROUNDUP(ROW()/4,0),IF(MOD(ROW(),4)=0,4,MOD(ROW(),4)))
Copy this formula down the page until errors occur. Delete the error cells, and there's your data.

Then add a column to the left and create the relevant row labels (over to you...).

Select the new table, choose Insert, Chart and follow the options...

hth
Mike

thx for your help, i took ur advice and managed to do it. instead of a 2 coloums a used 3 coloumns and used the formula u provided to sort the data out. thx again.

2001 Q1 150
Q2 156
Q3 162
Q4 168
2002 Q1 158
Q2 165
Q3 169
Q4 175
2003 Q1 165
Q2 172
Q3 177
Q4 183
2004 Q1 173
Q2 181
Q3 185
Q4 193
2005 Q1 180