building a graph that I will update once a date is selected

[Andy B1963]

Hi there guys

was hoping someone could assist (getting myself confused in how to build this one) trying to build a graph that auto builds once I select a date from a dropdown box (its for my recently installed solar array at home)
presently built this table but just can't seam to get my head around how to pull into a graph that will show me the info upon selecting a date. at the moment I have to extract the info day by day to view a graph (see attached)
any assistance in pointing me in the right direction would great
(everyday is a learning curve when it comes to excel)

 

[Kerryx]

Step 1 Merged cells and graphs dont really work well,
I'd put info into a table as you add info table will update, you can create chart from table and filter by date on table unless you are something more complex

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Date	kWh	00:00	00:05	00:10	00:15	00:20	00:25	00:30	00:35	00:40	00:45	00:50	00:55	01:00	01:05
2	16/09/2022	PV Out	2	1.5	1.5	1.45	1.6	1	1	1	1.55	1.42	1.9	1.22	1.2	1.1
3	16/09/2022	Cons	0.65	0.67	0.67	0.67	0.61	0.62	0.61	0.65	0.69	0.65	0.59	0.62	0.67	0.68
4	16/09/2022	Self- Cons	0	0	0	0	0	0	0	0	0	0	0	0	0	0
5	17/09/2022	PV Out	0	0	0	0	0	0	0	0	0	0	0	0	0	0
6	17/09/2022	Cons	0.62	0.62	0.55	0.68	0.65	0.44	0.25	0.65	0.8	0.8	0.58	0.62	0.69	0.7
7	17/09/2022	Self- Cons	0	0	0	0	0	0	0	0	0	0	0	0	0	0
8	18/09/2022	PV Out	0	0	0	0	0	0	0	0	0	0	0	0	0	0
9	18/09/2022	Cons	0.62	0.62	0.55	0.68	0.65	0.44	0.25	0.65	0.8	0.8	0.58	0.62	0.69	0.7
10	18/09/2022	Self- Cons	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Sheet3

All the data

 

[Andy B1963]

Hi thanks for your reply.

yep have already been filtering but wanted to build a worksheet/ report with other graphs that I have managed to sort which respond to a date selection from a dropdown list.
its just this one was giving me a bit of a headache