Have chart show each row of data?

[welshgasman]

Blood Pressures.xlsx
	A	B	C	D
1	DateTime	Systolic	Dystolic	Pulse
2	26/09/2024 14:15	164	86
3	26/09/2024 23:15	120	63
4	27/09/2024 09:25	155	82
5	27/09/2024 14:15	134	76	73
6	27/09/2024 22:58	143	89	58
7	28/09/2024 08:15	156	92	59
8	29/09/2024 10:02	147	78	80
9	29/09/2024 13:05	127	82	61
10	29/09/2024 19:38	155	89	91
11	29/09/2024 21:53	147	75	76
12	30/09/2024 08:36	145	80	64
13	30/09/2024 12:29	153	90	51
14	30/09/2024 22:20	141	79	64
15	01/10/2024 08:48	156	85	67
16	01/10/2024 13:45	138	84	73
17	01/10/2024 22:22	146	71	75
qryPressure

Hi all,
I have created an Excel table that takes data from an Access database.
It is meant to monitor my blood pressures taken several times during the day. Should be at least two when I remember.

However whilst the table is fine, I cannot get the chart to show each row of data. It insists on grouping all for a day into one.
Now this would not be too much of a problem, except for the fact one cannot distiguish which distolic and pulse goes with which systolic?

Is there a way to acoomplish this please?

TIA

 

[Marius44]

HI,
If I understand correctly, change the x-axis type to text.
Let me know. HI,
Mario

 

[welshgasman]

HI,
If I understand correctly, change the x-axis type to text.
Let me know. HI,
Mario

You understood perfectly.

Thank you, that worked like a dream.