Drop Down/Selection List to Populate a Graph

Hi,

I am attempting to create an automated monitoring spreadsheet at work and one of the things I was working on was the creation of a dynamically updating graph.

The idea is that a user would select a subject heading from a worksheet, which would then link to an external worksheet of the same name and use that data to update a chart. I also wanted to check if it is feasible to create a selection table where the options could be chosen individually or all together to populate the chart (with the axis remaining the same). I envisage this being in the form of option/radio buttons that can be selected, which would then correspond to what is depicted in the chart.

Any help on this would be great.

Please let me know if you require any further details on this.

Thanks

This can definitely be done and accomplished in quite a few ways, have any sample data, etc?

I have quickly done a mock version of my spreadsheet to demonstrate. How can I upload it?

Thanks

Hi all and thanks for your responses.

Attached is an example of the type of data that I will be using, though in the actual scenario the data that is used to populate the chart would sit externally. I'll be hoping to repeat this automation across many internal spreadsheets eventually.

Thanks again for all your help.

I'm still struggling with this. If anyone requires further information to help me with this, please do not hesitate to let me know.

Kind regards