How to graph from data selected by user

[nigelpet]

Hi

I have various datasets in columns against week numbers over a period of time.

I am looking for a way to graph the data in a single column that the user selects. The week number will always be the x axis and whichever metric is selected would need to be on the y axis.

essentially, I want the graph to update to show the correct metric when the user clicks the metric name.

Any ideas?

Thanks guys

 

[mole999]

maybe a predefined list of dropdown names for your selection and then a vlookup for the appropriate table of values