Dynamic Chart with multiple drop downs vba code

Hi

I need to create a excel macro for creating dynamic charts. In essence i will have data in Sheet1 of my workbook (column 1 will be time, col2 sales, and col3 onwards the media investments) and when i run the macro it should activate Sheet2 and in that provide two drop downs with all the series names in each drop down. i would wat a macro that plots any two series names as in the two drop downs with timeperiod on the x axis in the same sheet. so for example if in first drop down i select sales and in second tv invesment i get a line chart with time on x axis and sales and tv investment on the y axis....

any help in this regard would be greatly appreciated. please find attached the data for the same. Notice the Data length (columns can vary)