Doughnut graph with only one ring

[Red over White]

Fluff has been wonderful in configuring the figures so that the data set appears in the correct order. However, when I select H3:J30 and then select the doughnut graph from the lower Insert option, the cells in H3:I5 are not selected. I have asked Fluff if he knew the reason why, but he doesn't do graphs. I have previously created doughnut graphs with I values in the centre and Js on the outside.

Can anyone else help?

Thanks

Doughnut 2.xlsx
	A	B	C	D	E	F	G	H	I	J
1					15.000%
2
3	Example 1	0.3%		1	21.182%	2		Example 2	21.2%
4	Example 2	21.2%		2	19.345%	21		Example 21	19.3%
5	Example 3	0.3%		3	17.939%	14		Example 14	17.9%
6	Example 4	2.3%		4				Example 1		0.3%
7	Example 5	1.1%		5				Example 3		0.3%
8	Example 6	6.6%		6				Example 4		2.3%
9	Example 7	1.5%		7				Example 5		1.1%
10	Example 8	0.6%		8				Example 6		6.6%
11	Example 9	0.5%		9				Example 7		1.5%
12	Example 10	0.6%		10				Example 8		0.6%
13	Example 11	6.9%		11				Example 9		0.5%
14	Example 12	0.7%		12				Example 10		0.6%
15	Example 13	0.5%		13				Example 11		6.9%
16	Example 14	17.9%		14				Example 12		0.7%
17	Example 15	0.3%		15				Example 13		0.5%
18	Example 16	3.2%		16				Example 15		0.3%
19	Example 17	0.3%		17				Example 16		3.2%
20	Example 18	1.2%		18				Example 17		0.3%
21	Example 19	2.6%		19				Example 18		1.2%
22	Example 20	0.8%		20				Example 19		2.6%
23	Example 21	19.3%		21				Example 20		0.8%
24	Example 22	0.2%		22				Example 22		0.2%
25	Example 23	0.9%		23				Example 23		0.9%
26	Example 24	3.4%		24				Example 24		3.4%
27	Example 25	0.3%		25				Example 25		0.3%
28	Example 26	4.4%		26				Example 26		4.4%
29	Example 27	0.7%		27				Example 27		0.7%
30	Example 28	0.8%		28				Example 28		0.8%
Exclusion

Cell Formulas
Range	Formula
H3:J30	H3	=LET(b,B3:B30,c,F3:F30,f,FILTER(c,c<>""),r,WORKDAY.INTL(0,SEQUENCE(ROWS(b)-ROWS(f)),"0000000",f),rr,VSTACK(f,r),HSTACK(INDEX(A3:A30,rr),IF(c<>"",INDEX(b,rr),""),IF(c="",INDEX(b,rr),"")))
E3:E8	E3	=IF(LARGE($B$3:$B$30,D3)>E$1,LARGE($B$3:$B$30,D3),"")
F6:F30	F6	=IFERROR(SUM(MATCH(E6,$B$3:$B$30,0)+2),"")
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3	Cell Value	<=0.15%	text	NO

 

[myall_blues]

For me it only ignores the first three rows, but regardless to "force" it to recognise the entire dataset put labels over the two columns of data (I2 and J2 respectively) and leave H2 blank.

Like so:

Book1
	A	B	C	D	E	F	G	H	I	J
1					0.15
2									Data 1	Data 2
3	Example 1	0.003023		1	0.211816	2		Example 2	0.211816
4	Example 2	0.211816		2	0.193455	21		Example 21	0.193455
5	Example 3	0.002961		3	0.179387	14		Example 14	0.179387
6	Example 4	0.022512		4				Example 1		0.003023
7	Example 5	0.011177		5				Example 3		0.002961
8	Example 6	0.066133		6				Example 4		0.022512
9	Example 7	0.01478		7				Example 5		0.011177
10	Example 8	0.006416		8				Example 6		0.066133
11	Example 9	0.00476		9				Example 7		0.01478
12	Example 10	0.005942		10				Example 8		0.006416
13	Example 11	0.069496		11				Example 9		0.00476
14	Example 12	0.006744		12				Example 10		0.005942
15	Example 13	0.004738		13				Example 11		0.069496
16	Example 14	0.179387		14				Example 12		0.006744
17	Example 15	0.002764		15				Example 13		0.004738
18	Example 16	0.031586		16				Example 15		0.002764
19	Example 17	0.002961		17				Example 16		0.031586
Sheet1

Cell Formulas
Range	Formula
H3:J30	H3	=LET(b,B3:B30,c,F3:F30,f,FILTER(c,c<>""),r,WORKDAY.INTL(0,SEQUENCE(ROWS(b)-ROWS(f)),"0000000",f),rr,VSTACK(f,r),HSTACK(INDEX(A3:A30,rr),IF(c<>"",INDEX(b,rr),""),IF(c="",INDEX(b,rr),"")))
E3:E8	E3	=IF(LARGE($B$3:$B$30,D3)>E$1,LARGE($B$3:$B$30,D3),"")
F6:F19	F6	=IFERROR(SUM(MATCH(E6,$B$3:$B$30,0)+2),"")
Dynamic array formulas.

 

[Red over White]

Thanks MB - just for clarity for anyone else who reads this, you need to select H2:J30 before going to Insert.

Thanks again.

 

[myall_blues]

Thanks MB - just for clarity for anyone else who reads this, you need to select H2:J30 before going to Insert.

Thanks again.

You’re welcome, and thank you for adding the clarification. I meant to say that but forgot.