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