How to create a scatter chart from non-adjacent table columns?

[JenniferMurphy]

I want to create a scatter chart from the table below with the #Reviews column (D) on the X axis and the Conf Int column (G) on the Y axis.

What I have done is to hide all the intervening columns (E & F), select the two now adjacent columns (D & G), and insert a scartter chart.

Perfect. That is until I unhide the hidden columns. When I do, the chart goes berzerk. It appears to now include all of the intervening columns.

What am I doing wrong and, more importantly, how do I do it right?

Thanks

Here's that table

Std Dev & Variance.xlsm
	B	C	D	E	F	G	H
2					Alpha	0.05
3
4	SKU	Rating	#Reviews	Mean	Std Dev	Conf Int	Rtg Adj
5	B0822KNQKT	4.7	67,027	4.6800	0.7474	0.007	4.693
6	B004HZFASG	4.8	27,183	4.7400	0.7432	0.011	4.789
7	B08R7NLL3R	4.3	12,175	4.3100	1.3190	0.017	4.283
8	B086MBQKH2	4.6	10,113	4.5600	0.9625	0.018	4.582
9	B093VNWP94	4.6	8,157	4.6800	0.8346	0.021	4.579
10	B0928PHM2B	4.1	1,924	4.6300	0.8325	0.042	4.058
11	B08RWMY1MW	4.4	1,447	4.4100	1.1322	0.049	4.351
12	B0BTHJZ1KM	4.8	1,001	4.7900	0.6371	0.059	4.741
13	B08RYJ3ZZJ	4.4	429	4.3900	1.1480	0.090	4.310
14	B081T9X7RZ	4.8	371	4.7300	0.6272	0.096	4.704
15	B00FHW7PHW	3.7	149	3.6900	1.6291	0.152	3.548
16	B07FMC8N7H	4.5	91	4.5400	0.9942	0.195	4.305
17	B08JYQZ21S	3.9	47	3.8600	1.5101	0.271	3.629
18	B002VL628U	3.8	7	3.8200	1.5961	0.702	3.098
19	B0BVVTL388	4.7	5	4.7100	0.4538	0.831	3.869
20	B0BRMLQBG7	5.0	1	5.0000	0.0000	1.858	3.142
21	Averages	4.4	8,133	4.4713	0.9479	0.276	4.168
Chart

Cell Formulas
Range	Formula
G5:G20	G5	=CONFIDENCE.NORM(Alpha,Table25[[#Totals],[Std Dev]],[@['#Reviews]])
H5:H20	H5	=[@Rating]-[@[Conf Int]]
C21	C21	=SUBTOTAL(101,[Rating])
D21	D21	=SUBTOTAL(101,['#Reviews])
E21	E21	=SUBTOTAL(101,[Mean])
F21	F21	=SUBTOTAL(101,[Std Dev])
G21	G21	=SUBTOTAL(101,[Conf Int])
H21	H21	=SUBTOTAL(101,[Rtg Adj])

Named Ranges
Name	Refers To	Cells
Alpha	=Chart!$G$2	G5:G20

 

[RoryA]

Personally I like to create a blank chart then add the series using the Select Data option (right-click the chart)

 

[JenniferMurphy]

Personally I like to create a blank chart then add the series using the Select Data option (right-click the chart)

I tried that several times, but never got it to work. I checked about a dozen web pages, but none of them take the data from a table table.

Any clues to the secret to get a scatter chart from this table with the #Reviews column on the X-axis and the Conf Int column on the Y-axis?

Std Dev & Variance.xlsm
	B	C	D	E	F	G	H
2					Alpha	0.05
3
4	SKU	Rating	#Reviews	Mean	Std Dev	Conf Int	Rtg Adj
5	B0822KNQKT	4.7	67,027	4.6800	0.7474	0.007	4.693
6	B004HZFASG	4.8	27,183	4.7400	0.7432	0.011	4.789
7	B08R7NLL3R	4.3	12,175	4.3100	1.3190	0.017	4.283
8	B086MBQKH2	4.6	10,113	4.5600	0.9625	0.018	4.582
9	B093VNWP94	4.6	8,157	4.6800	0.8346	0.021	4.579
10	B0928PHM2B	4.1	1,924	4.6300	0.8325	0.042	4.058
11	B08RWMY1MW	4.4	1,447	4.4100	1.1322	0.049	4.351
12	B0BTHJZ1KM	4.8	1,001	4.7900	0.6371	0.059	4.741
13	B08RYJ3ZZJ	4.4	429	4.3900	1.1480	0.090	4.310
14	B081T9X7RZ	4.8	371	4.7300	0.6272	0.096	4.704
15	B00FHW7PHW	3.7	149	3.6900	1.6291	0.152	3.548
16	B07FMC8N7H	4.5	91	4.5400	0.9942	0.195	4.305
17	B08JYQZ21S	3.9	47	3.8600	1.5101	0.271	3.629
18	B002VL628U	3.8	7	3.8200	1.5961	0.702	3.098
19	B0BVVTL388	4.7	5	4.7100	0.4538	0.831	3.869
20	B0BRMLQBG7	5.0	1	5.0000	0.0000	1.858	3.142
21	Averages	4.4	8,133	4.4713	0.9479	0.276	4.168
Chart

Cell Formulas
Range	Formula
G5:G20	G5	=CONFIDENCE.NORM(Alpha,Table25[[#Totals],[Std Dev]],[@['#Reviews]])
H5:H20	H5	=[@Rating]-[@[Conf Int]]
C21	C21	=SUBTOTAL(101,[Rating])
D21	D21	=SUBTOTAL(101,['#Reviews])
E21	E21	=SUBTOTAL(101,[Mean])
F21	F21	=SUBTOTAL(101,[Std Dev])
G21	G21	=SUBTOTAL(101,[Conf Int])
H21	H21	=SUBTOTAL(101,[Rtg Adj])

Named Ranges
Name	Refers To	Cells
Alpha	=Chart!$G$2	G5:G20

 

[RoryA]

You should be able to just select the Reviews column then ctrl+click to select the Conf Int column, then insert a scatter chart.

 

[JenniferMurphy]

You should be able to just select the Reviews column then ctrl+click to select the Conf Int column, then insert a scatter chart.

Well, D*mn! I thought I tried that. (sigh) Thanks