Converting cell value to table name to use in charts

user_12303018 0
Viewed 26

I have a spreadsheet with a few Tables i.e. Art, Drama, English etc. I want to create a dynamic chart so when I change cell B1 to Art the chart automatically picks up the table Art. Is there any way to do this?

Thanks

excel-formula
1 Answers

Not exactly what you are asking for but maybe good enough: Set up data series as in the picture and use the filter in the graph enter image description here enter image description here

enter image description here

user_23101540
Related