Coloured segments on a spider plot

[John David McKinley]

OK, I'm a long time reader of MrExcel, great resource, but this has me stumped and I can't find anything here. How do I make a spider plot with filled in segments of different angles? What I am trying to do is make a spider plot for data which has 18 categories, called M1 through M18, in Office Excel for Mac 16.80, with a background that is different segments of the circle shaded to indicate related topics. That is, M1 is Topic 1, M2 through M4 are Topic 2, M5 and M6 are topic 3, and so on. The closest I can get looks almost right, except there is an uncoloured segment between the first and the last category, i.e. where the data wraps around. The way I have got it to this point is by having a blank cell category for each actual category, to give me a separation, and a separate set of data series for the coloured segments. I just can't get it to colour the segment between the last category and the first. If I add another category after the M18, the M18 entry expands but there is still a blank segment inserted.

AHEP 4 mapping chart 2023 12 13.xlsx
	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN
251	Scale		25		25		25		25		25		25		25		25		25		25		25		25		25		25		25		25		25		25
252	MEng Civil		M1		M2		M3		M4		M5		M6		M7		M8		M9		M10		M11		M12		M13		M14		M15		M16		M17		M18
253	By Level 1	5	6	6	6	5	4	2.5	1	2	3	2.5	2	2.5	3	2.5	2	1	0	0	0	0.5	1	2	3	2	1	2	3	3	3	3	3	4.5	6	5	4
254	By Level 2	8.5	11	11	11	10	9	7.5	6	6.5	7	5.5	4	5	6	5.5	5	3	1	2	3	3	3	5	7	5	3	3.5	4	6	8	7.5	7	9	11	8.5	6
255	By Level 3	11.5	16	16.5	17	15.5	14	12	10	10.5	11	10	9	9.5	10	8.5	7	6	5	5.5	6	4.5	3	5	7	6	5	6	7	9.5	12	11.5	11	13.5	16	11.5	7
256	By Level 4	15	20	20.5	21	19	17	15.5	14	14	14	13.5	13	13	13	11	9	7.5	6	6	6	5.5	5	7	9	8	7	8.5	10	12.5	15	16	17	19	21	15.5	10
257
258			M1		M2		M3		M4		M5		M6		M7		M8		M9		M10		M11		M12		M13		M14		M15		M16		M17		M18
259	Science and Maths	25	25	25
260	Engineering Analysis			25	25	25	25	25	25	25
261	Design and Innovation									25	25	25	25	25
262	The Engineer and Society													25	25	25	25	25	25	25	25	25	25	25
263	Engineering Practice																							25	25	25	25	25	25	25	25	25	25	25	25	25	25
MEng Civil AHEP 4

 

[John David McKinley]

Gah, sorry guys it turns out to be fairly simple but I just couldn't see it — the last topic need to wrap around to the first, so cell E263 needs to have a 25 in it making each category span across three columns, two of its own and one here it joins the next. It's simply that the last topic needs to join on to the first.