Chart with conditional chart data

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. The range is not an area where data would be manually entered but would be populated based on pre-existing formulas in each cell in the range.

Hi,
You must define three dynamic names:
"Xaxis" with

Formula:

=OFFSET(Sheet1!$E$5,,,1,IF(Sheet1!$B$2=1,3,8))

"ValA" with

Formula:

=OFFSET(Sheet1!$E$6,,,1,IF(Sheet1!$B$2=1,3,8))

and "ValB" with

Formula:

=OFFSET(Sheet1!$E$7,,,1,IF(Sheet1!$B$2=1,3,8))

and using these names in Slect Data Suorce, adding the file name in front of the name defined
for Axis label range:

Formula:

=DinamicChart.xlsx!Xaxis

for Series values:

Formula:

=DinamicChart.xlsx!ValA

and

Formula:

=DinamicChart.xlsx!ValB

see attached

Awesome! This is all new to me but I think I can weed through it...Thanks!