Complex Graph Problem, 4 Data sets Plus Date & Time

[Joneye]

Hi there,

Im looking to plot a graph to display Date & Time on an X axis then Soil Nutrients, Soil Moisture then Temperature & Humidity on the Y Axis. Im completely stumped if its.

A. Possible
B, If it is what web links can i follow that have achieved this before
C. Is there another method of displaying this

 

[ravi2628]

Hi
Have you tried like this. as data is in image format so I have tried with sample data

Book1
	A	B	C	D	E	F	G	H	I	J	K
21	Date		Original Table						Chart Table
22	10-Oct-2021	09-Oct-2021	Date	Time	Soil	Moisture			Time	Soil	Moisture
23		10-Oct-2021	09-Oct-21	11:30:00	0.28	63.80			11:30:00	0.28	63.8
24			09-Oct-21	11:40:00	0.28	63.80			11:40:00	0.28	63.8
25			09-Oct-21	11:55:00	0.29	64.04			11:55:00	0.29	64.04
26			09-Oct-21	12:10:00	0.29	64.04			12:10:00	0.29	64.04
27			10-Oct-21	11:30:00	0.28	63.80
28			10-Oct-21	11:40:00	0.28	63.80
29			10-Oct-21	11:55:00	0.29	64.04
30			10-Oct-21	12:10:00	0.29	64.04
Sheet1

Cell Formulas
Range	Formula
B22:B23	B22	=UNIQUE(C23:C30,0,0)
I23:I26	I23	=UNIQUE(FILTER(D23:D30,C23:C30,B22))
J23:J26	J23	=INDEX($E$23:$E$30,MATCH(1,(I23=$D$23:$D$30)*($A$22=$C$23:$C$30),0))
K23:K26	K23	=INDEX($F$23:$F$30,MATCH(1,(I23=$D$23:$D$30)*($A$22=$C$23:$C$30),0))
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
A22	List	=$B$22:$B$30

 

[Joneye]

Thank you this is a fabulous help, i guess its pretty complex to get it sat simple (so to speak). This does help lots thank you

 

[ravi2628]

Thank you this is a fabulous help, i guess its pretty complex to get it sat simple (so to speak). This does help lots thank you

You are welcome.


and also can you mark it as a solution