Selecting different graphs from a drop down box

[joe90]

I have
a list of 12 people down column A
a score for each person for each month (Jan-Dec) from column B to M

What I'd like to be able to do is have one chart below the table that has a drop down box so I can select one persons name at a time and have their scores automatically plotted on it.

Any idea how I do this?

[Andy Pope]

You can use data validation to select person to chart

The use the MATCH formula to tell you the row position of the selected person.
Use INDEX to create a row of chart data.

See attached,

[joe90]

Superb, thanks!