interactive drop down list

[orange4350]

Problem: how to create an interactive drop down list
Version: Office 2007

I have been working quite some time on making an excel sheet and gone through quite a lot of tutorials. If this is already posted can you can please refer me to the original post.

I have been working on a summary excel sheet which gathers data from other sheets and displays the metrics in a chart.

You can select year:
2009 / 2008

And than you a have drop down list -> "Select key metrics":
Total ranking found
# of top 10 rankings
............
............

If you click on a key metric the chart changes but all other info stays the same (see example: )

What do I have to do make a drop down list that changes the chart everytime I select a different key metric?

Looking forward to your feedback.

 

[shemayisroel]

Hi & Welcome,


I think what your looking for is a dependent drop list? If thats the case then the below will help you achieve what you want...

http://www.contextures.com/xlDataVal02.html

 

[orange4350]

Thanks a lot...this is what I was looking for

 

[shemayisroel]

Thanks a lot...this is what I was looking for

No worries, your welcome.