I want to add a chart to my spreadsheet so that when Cell B2 changes (options are 1 or 2 based on radio buttons), then the chart data changes.

IE:

If B2 = 1
Then the chart data range is D5:G7

If B2 = 2
Then the chart data range is D5:L7


I want to do this without VBA. Is there an easy way? I tried plugging in a formula in the data range selector but, obviously, it didn't work.