Automatic Graph in Excel
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
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.
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?