I need help in creating a date vs score chart in excel. The issue is that the chart should have a drop-down list containing the name of the sheets which have the data in it in such a way that when a sheet is selected from the list the chart displays the data regarding that particular sheet. I don't mind using macros to accomplish the task, so please guide me on how I can do it. Unfortunately I cannot attach the file since its 6MB size.