Need some help here - I have a HUGE workbook which I am putting together and am trying to do a bar graph to manipulate an "option" type of drop down list (button) to separate my data out by month/yearly/bi-annual/etc. PLUS I need to link a pie chart pulling the same type of ption button but a different set of series to the same button so that when I choose my "type" in my drop down list they will populate together.