Hi there I have a problem. I need to insert 4 drop down lists. In each list will have the 52 weeks divided between them. What I want to do is select a number eg: 42 from the forth drop down list, and it then display a pie chart either on the excel sheet its self or as a new window.
Any suggestions

Many thanks