Lake Level Measurement Chart.

[Butch-196]

Hi Hopefully someone can help! I would like to display the following data as a chart, however the chart is only showing the time and not the date. I would also like the chart to have the percentage level and pump status displayed.

Date	Time	Bore Hole Pump Status	Bore Hole Pump Status %	Lake Level %
01/06/2022​	12:00:00​	on	100​	65​
01/06/2022​	13:00:00​	on	100​	66​
01/06/2022​	14:00:00​	on	100​	62​
01/06/2022​	15:00:00​	on	100​	67​
01/06/2022​	16:00:00​	on	100​	63​
01/06/2022​	17:00:00​	on	100​	61​
01/06/2022​	18:00:00​	on	100​	60​
01/06/2022​	19:00:00​	on	100​	64​
01/06/2022​	20:00:00​	on	100​	65​
01/06/2022​	21:00:00​	on	100​	63​
01/06/2022​	22:00:00​	on	100​	65​
01/06/2022​	23:00:00​	on	100​	63​
02/06/2022​	00:00:00​	off	50​	55​
02/06/2022​	01:00:00​	off	50​	55​
02/06/2022​	02:00:00​	off	50​	55​
02/06/2022​	03:00:00​	off	50​	55​
02/06/2022​	04:00:00​	off	50​	55​
02/06/2022​	05:00:00​	off	50​	55​
02/06/2022​	06:00:00​	off	50​	55​
02/06/2022​	07:00:00​	on	100​	65​
02/06/2022​	08:00:00​	on	100​	66​
02/06/2022​	09:00:00​	on	100​	62​
02/06/2022​	10:00:00​	on	100​	67​
02/06/2022​	11:00:00​	on	100​	63​
02/06/2022​	12:00:00​	on	100​	61​
02/06/2022​	13:00:00​	on	100​	60​
02/06/2022​	14:00:00​	on	100​	64​
02/06/2022​	15:00:00​	on	100​	65​
02/06/2022​	16:00:00​	on	100​	63​
02/06/2022​	17:00:00​	on	100​	65​
02/06/2022​	18:00:00​	on	100​	63​
02/06/2022​	19:00:00​	on	100​	63​
02/06/2022​	20:00:00​	on	100​	63​

 

[6StringJazzer]

You need to combine the time and date into a single column and use that for the x-axis. To use your existing data you would insert a new column and simply add them. Also make sure both these columns are date and time data, and not text strings.

$scratch.xlsm
	A	B	C	D	E	F
1	Date	Time	Date+Time	Bore Hole Pump Status	Bore Hole Pump Status %	Lake Level %
2	01/06/2022	12:00:00	01/06/2022 12:00:00	on	100	65
3	01/06/2022	13:00:00	01/06/2022 13:00:00	on	100	66
4	01/06/2022	14:00:00	01/06/2022 14:00:00	on	100	62
5	01/06/2022	15:00:00	01/06/2022 15:00:00	on	100	67
6	01/06/2022	16:00:00	01/06/2022 16:00:00	on	100	63
7	01/06/2022	17:00:00	01/06/2022 17:00:00	on	100	61
8	01/06/2022	18:00:00	01/06/2022 18:00:00	on	100	60
9	01/06/2022	19:00:00	01/06/2022 19:00:00	on	100	64
10	01/06/2022	20:00:00	01/06/2022 20:00:00	on	100	65
11	01/06/2022	21:00:00	01/06/2022 21:00:00	on	100	63
12	01/06/2022	22:00:00	01/06/2022 22:00:00	on	100	65
13	01/06/2022	23:00:00	01/06/2022 23:00:00	on	100	63
14	02/06/2022	00:00:00	02/06/2022 00:00:00	off	50	55
15	02/06/2022	01:00:00	02/06/2022 01:00:00	off	50	55
16	02/06/2022	02:00:00	02/06/2022 02:00:00	off	50	55
17	02/06/2022	03:00:00	02/06/2022 03:00:00	off	50	55
18	02/06/2022	04:00:00	02/06/2022 04:00:00	off	50	55
19	02/06/2022	05:00:00	02/06/2022 05:00:00	off	50	55
20	02/06/2022	06:00:00	02/06/2022 06:00:00	off	50	55
21	02/06/2022	07:00:00	02/06/2022 07:00:00	on	100	65
22	02/06/2022	08:00:00	02/06/2022 08:00:00	on	100	66
23	02/06/2022	09:00:00	02/06/2022 09:00:00	on	100	62
24	02/06/2022	10:00:00	02/06/2022 10:00:00	on	100	67
25	02/06/2022	11:00:00	02/06/2022 11:00:00	on	100	63
26	02/06/2022	12:00:00	02/06/2022 12:00:00	on	100	61
27	02/06/2022	13:00:00	02/06/2022 13:00:00	on	100	60
28	02/06/2022	14:00:00	02/06/2022 14:00:00	on	100	64
29	02/06/2022	15:00:00	02/06/2022 15:00:00	on	100	65
30	02/06/2022	16:00:00	02/06/2022 16:00:00	on	100	63
31	02/06/2022	17:00:00	02/06/2022 17:00:00	on	100	65
32	02/06/2022	18:00:00	02/06/2022 18:00:00	on	100	63
33	02/06/2022	19:00:00	02/06/2022 19:00:00	on	100	63
34	02/06/2022	20:00:00	02/06/2022 20:00:00	on	100	63
charting

Cell Formulas
Range	Formula
C2:C34	C2	=A2+B2