Color coding lines on a chart based

[catandhorse1976]

Hello,

I have data on over 65 patients collected at over 7 time points during hospitalisation. For each patient I also have the occurrence 10 types of complication recorded.

The data are coded, 0= complication did not occur and 1= complication did occur, but for some complications there are no data for some patients - for example when the patient did not leave hospital.

I have plotted the data for all patients (see image attached). But I want to create a separate chart for each complication whereby affected patients can be distinguished from non-affected, for example, by making the data points for affected patients large X or squares and their lines thicker or dashed. The chart colors and lines for non-affected patients can remain the default.

Thank you.

PCT-SAA-HorseTrust-Update-2023-03-10.xlsx
	A	B	C	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	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL
1	HorseID	PCT-1(ColicSx)	PCT-7(PTSTable)	PCT-8(ColicSx)	PCT-9(ColicSx)	PCT-10(ColicSx)	PCT-11(ColicSx)	PCT-13(PTS-Table)	PCT-14(PTS-Hosp)	PCT-15(PTS-Table)	PCT-16(ColicSx)	PCT-17(ColicSx)	PCT-18(ColicSx)	PCT-2(ColicSx)	PCT-20(ColicSx)	PCT-21(Caesar-LaterPTS-Table)	PCT-22(ColicSx)	PCT-23(Caesar)	PCT-24(Caesar)	PCT-25(Caesar)	PCT-26(ColicSx)	PCT-28(PTSRecovery#)	PCT-29(ColicSx)	PCT-3(ColicSx)	PCT-30(ColicSx)	PCT-31(ColicSx)	PCT-32(ColicSx)	PCT-33(ColicSx)	PCT-34(ColicSx)	PCT-35(Caesar)	PCT-36(InfHematoma)	PCT-37(UterusTear)	PCT-38(ColicSx-PTS-Recovery)	PCT-39(ColicSx)	PCT-4(ColicSx)	PCT-40(ColicSx)	PCT-41(ColicSx)	PCT-42(ColicSx)	PCT-43(ColicSx)	PCT-44 (ColicSx)	PCT-45(ColicSx)	PCT-46(ColicSx)	PCT-47(ColicSx)	PCT-48(ColicSx)	PCT-49(ColicSx)	PCT-5(ColicSx)	PCT-5(ColicSx)	PCT-50(ColicSx)	PCT-51(ColicSx)	PCT-52(ColicSx)	PCT-53(ColicSx)	PCT-54()	PCT-55(ColicSx)	PCT-56(ColicSx)	PCT-57(PTS-DayPostSx)	PCT-58 (PTS-Table)	PCT-59	PCT-6(ColicSx)	PCT-60( Colic)	PCT-61(CoilcSx)	PCT-62(ColicSx)	PCT-63(ColicSx)	PCT-64(ColicSx)	PCT-65(ColicSx)
2	SAA-D0 Day of Sx (in most cases = day of admit)	0.7	70.2	0.1	2.9	0		31.6	35.2	192.2	0		0.3	0.8		0.1	4.7	0.5	0	0.3	0.1	A	0	896.4	0	1.2		0		0.5	355.6	50.7			134.5	0.2	0.1	0	0		0.1	0.6	551.8	0.9	0.7	54.5	54.5		0	0.3	0.7	0	122.8	0		0.5	0	0	0				10
3	SAA-D1				1136		819.3								47		583.1	440					0				3648					512.2								268	574.4												442.3		163			983.5		480.5	504.2	166
4	SAA-D2				365.9	394.8	404.7		406.6		382.5	374.5	391.4		518.2		424.8	336	460	494.9	541		650	1377	2.69	3085	3900	1041	841			325.7		289.7	323.1	320	292.3	320.7			307	376.9	282.1		391.3	310.9	310.9			379.9			363.5	306.7			252.3	403.1			359.5		390	1407
5	SAA-D3				365									390.1			362			546				1126				642				307.1		264.5				319											488.7												350	7
6	SAA-D4	354.8		395.2	360.2	446.9	338.6		280.3		383.6	325.5	429.8	395.1			502	405	537	158.8	155.9		2228		712	3900	3118	514	138			327.4		263	365.2	279.8	278.8	392.2		267.7	285.3	457.7	393		481.7	436.6	436.6	313.5						410			499.2	1168		416.2	407.3		62	450
7	SAA-D5			1463		1366	151.7				417.5	351.1	549.4										2013			4817					282.6	332.3			428.4													402.6	405.2									467.2
8	SAA-D6	121.9		46.1	319.6	982					412.7		590.6	378.9						470			650		3879					613				272.1	1209	313.2	358.4			220	380.4			317.1	428.3	255	255		37.7		530		497.1							518.7			0
9	SAA-D7	285.5			313.4								529																					328.4		319.3						201.3						526.1		563			532.9
10	IncisionalInf Hosp I(Hosp)	0		0	0	0	0		0		0	0	0	0	0		0	0	0	0	0		1	0	0	0	0	0	0	0	0	0		0	0	0	0	0		0	0	0	0	0	0	0	0	1	0	0	0	PTS Table	0	0	0		0	0		0	0	0	0	0
11	New InisionalINFAfterDischarge I(Home)	0		1	1	0	0				1	0	0	0	0		0	0	0	0	0		0	0	0	0	0	0	0	0	Unknown	1		0	0	1		0		0	0	0	0	0	0	0	0	0	0	0	0	PTS Table	0	0			Unknown	0		0	0	0	0
12	CatheterAssocComplic in Hosp C(Hosp)	0		0	0	0	0		0		0	0	0	0	0		0	0	0	0	0		1	0	0	0	0	0	0	0	1	0		0	0	0	1	0		0	0	0	0	0	0	0	0	0	0	0	0	PTS Table	0	0	0		0	0		0	0	0	0	0
13	NEW CatheterAssocComplic C(Home))	0		0	0	0	0				0	0	0	0	0		0	0	0	0	0		0	0	0	0	0	0	0	0	Unknown	0		0	0	0		0		0	0	1	0	0	0	0	0	0	0	0	0	PTS Table	0	0	0		Unknown	0		0	0	0	0
14	AnyCatheter Assoc Complic = Hosp or Home C(HospOrHome)	0		0	0	0	0		0		0	0	0	0	0		0	0	0	0	0		1	0	0	0	0	0	0	0	1	0		0	0	0	1	0		0	0	1	0	0	0	0	0	0	0	0	0	PTS Table	0	0	0		Unknown	0		0	0	0	0
15	Other Infections Hosp or Home excl incision or Cath (see notes on Complications)	0		0	0	0	0		0		0	0	0	0	0		0	0	0	0	0		1	0	0	1	0	0	0	0	Uknown	0		0	0	0	1	0		0	0	0	0	0	0	0	0	0		0	0	PTS Table	0	0	0		Unknown	0		0	0	0	0
16	Any NEW Inf (Incision or Catheter or Other)	0		1	1	0	0				1	0	0	0	0		0	0	0	0	0		0	0	0	0	0	0	0	0	Unknown	1		0	0	1		0		0	0	1	0	0	0	0	0	0	0	0	0	PTS Table	0	0			Unknown	0		0	0	0	0
17	AnyInfection = in HOSP (Incision or Catheter or Other)	0		0	0	0	0		0		0	0	0	0	0		0	0	0	0	0		1	0	0	1	0	0	0	0	1	0		0	0	0	1	0		0	0	0	0	0	0	0	0	1	0	0	0	PTS Table	0	0	0		0	0		0	0	0	0	0
18	AnyInfection = Hosp or Home, Incision or Catheter or Other	0		1	1	0	0		0		1	0	0	0	0		0	0	0	0	0		1	0	0	1	0	0	0	0	1	1		0	0	1	1	0		0	0	1	0	0	0	0	0	1	0	0	0	PTS Table	0	0	0		Unknown	0		0	0	0	0
19	SIRS in Hosp	0		0	0	0	0		1		0	0	0	0	0		0	0	1	0	0		1	0	0	1	0	0		0	Unknown	1	Limited data recorded	0	0	1	0	0		1	0	0	1	0	0	1	1	0	1	1	0	PTS Table	0	0	1		0	1		0	1	0	0	0
20	Non-survival to hospital discharge - first admission (1= non survival; 0=survival)	0	1	0	0	0	0	1	1		0	0	0	0	0	1	0	0	0	0	0	1	0	0	0		0	0	0	0	0	0	1	0	0	0	0	0	1	0		0	0	0	0	0	0	0	0	0	0	1	0	0	1	1	0	0		0	0	0	0	0
21	ANY Complic = I OR C OR R OR D OR Colic OR SIRS OR Death Hosp or Home	1	1	1	1	0	0	1	1	1	1	0	0	0	0	1	0	0	1	0	0	1	1	0	0	1	1	0	1	0	1	1	1	0	0	1	1	0	1	0	0	1	1	0	0	1	1	1	1	1	0	1	0	0	1	1	Unknown	1		0	1	0	0
(1b)SAA Plot

 

[catandhorse1976]

Any suggestions please?

Thank you.