Hello,
Thank God for this forum! I am new to writing macros and need help. I am currently working on a statistical analysis and I would like to have a chart with a drop down list. When I drop down the list and pick a number, i would like the chart to to plot series of data from the different sheets corresponding to the dropdown list number - a plot of count dates vs count 1 and count 2. I have tried couple of codes I saw on you tube and other forum and it didn't work. Couple of examples I saw in the forum described when all the data are in the same sheet with the chart.
Please see the attached sheet
Your help will be appreciated

counts.xlsm

Thanks

T