Selecting scatter X/Y ranges via droplist

[Derailed_Gerbil]

I've tried to find a solution for this without luck.

I have a list of values sorted in columns:
ex.

A1​	A2​	A3​	B1​	B2​	B3​
2​	1​	3​	1​	2​	4​
5​	7​	2​	3​	7​	2​

I want one scatter plot that plots A# vs B#, and I want to choose which column A1-3 and B1-3 to plot via cell-values in the sheet.

Is this possible?

 

[KRice]

Welcome to the MrExcel board! I do this occasionally using two helper columns, which are plotted. The helper columns in your case would each take the form:
=INDEX(A#,,x)
=INDEX(B#,,y)
...where x and y are the column index numbers in each range (or replace x and y with a common n if you want A1 vs B1 always, A2 vs B2 always, etc.). This pulls only the relevant columns into the helper columns and it is only those two columns that are plotted.
But I'm confused by something. Your profile indicates that you're using Excel 2016 but you've used a "spilling" nomenclature. Some adjustment may be necessary if using 2016...e.g.:
=INDEX($A$2:$C50,,x)
=INDEX($D$2:$F$50,,y)
In the example, blue cells are column index inputs and green cells are plotted.

MrExcel_20220831.xlsx
	A	B	C	D	E	F	G	H	I
1	A1	A2	A3	B1	B2	B3		1	2
2	1	5	9	1	25	81		x	y
3	2	6	10	4	36	100		A1	B2
4	3	7	11	9	49	121		1	25
5	4	8	12	16	64	144		2	36
6								3	49
7								4	64
Sheet2

Cell Formulas
Range	Formula
D2:F5	D2	=A2^2
H3	H3	=INDEX(A1:C1,,H1)
I3	I3	=INDEX(D1:F1,,I1)
H4:H7	H4	=INDEX($A$2:$C$5,,H1)
I4:I7	I4	=INDEX($D$2:$F$5,,I1)
Dynamic array formulas.

 

[Derailed_Gerbil]

Thank you for the answer, it works like charm!
the spilling nomenclature was an accident, the # indicated a number but a better way would've been A.

 

[Derailed_Gerbil]

Thank you for the answer, it works like charm!
the spilling nomenclature was an accident, the # indicated a number but a better way would've been A.

Can't find how to edit...

anyways the thumb down was supposed to be A( n )

 

[KRice]

You’re welcome…I’m happy to help. About that editing comment…the board implements a10 minute timer during which you can edit your post by clicking on a small “edit” link below your post, make necessary changes, and then resave the new version. After 10 minutes, the “edit” link disappears and you’re out of luck, unless it’s something really important…then you can discuss with a moderator.