[ms office - 2007] Automatic Graph in Excel

[cgiuk]

Quick question for any Excel geniuses out there. I have a sheet in Excel which contains pupils' names and their spelling ages throughout their school career.

 

At the moment, i've got all the information feeding into a bar chart but it displays every child's data on one big chart. Is there a way of adding something like a dropdown list to the chart so that a user can pick which child's data they want to chart?

 

Thanks for any help

[Ric_]

In Office 2010 you can add 'sparklines' or bar charts within a cell next to each dataset... not sure how useful this would be to solving your problem though.

[cgiuk]

Thanks for that Ric - the sparklines look great but it would involve us buying third party software to achieve that in Office 2007. Looks interesting though

 

Any other ideas?

Edited May 20, 2010 by cgiuk