Dynamically change X-axis as per dropdown selection

I have a Excel graph that displays number of students enrolled in each course for academic year 2013 and 2014. I have created a drop down box for years and count for both years for each course. I want my graph to display results for 2013 when I select 2013 in dropdown and for 2014 when I select 2014 in the drop down list. I tried to do this but, when I select 2013 the graph displays data for that year and also displays 0 count next to each course. I hope I made question clear. Waiting for replies

Could you post your workbook (sanitised if necessary). Makes it far easier to provide a solution.

BSB.

Hey,

I tried to prepare a sample sheet to post over here and I got my result... Thank you for ur interest to solve my question...