Using Combobox to change data being graphed

[tehmonker]

Hey guys, I have a main worksheet that has data in three rows and five columns, and there is a graph being displayed of that data beneath it.

I also have the same format of data on 3 other sheets that I am using.


So essentially, I want the main page to have a combobox (or dropdown) that when a certain term is selected, it changes the data being display (pulls the data from one of the other work sheets) and regraphs it.

[Andy Pope]

There are many posts on the forum, search for dynamic charts.