Dynamically changing a chart dataset based on dropdown value

[gparry]

Hi,

I have a chart which fetches its data from a dataset. on the sheet i also have a dropdown list with values in it. I want the chart to use a different data set based on the value of the dropdown list. is this possible?

thanks

Gareth