VBA Chart generator - Help

[tjrobo19]

Is it possible to have a vba script to generate daily chart sheets (one day per chart sheet) from a worksheet data set?

Any help would be greatly appreciated.


Example data set

Date	Time	Lmax	L1	L5	L10	L50	L90	L95	L99	Lmin	Leq	Relative Humidity (%)	Temp (Deg C)	Temp 2 (Deg C)	Rainfall (mm)	Mean Wind Speed (m/s)	Gust Wind Speed (m/s)	Solar Radiation (W/m^2)	Wind Direction (Degrees)
28-Nov-17	13:15	91.3	67	61.7	59.3	55.1	52.8	52.1	51.1	50.2	59.5	100	18.9		0	1.944444			67.5
28-Nov-17	13:30	87.2	66	60.6	58.4	53.9	52.2	51.9	51.1	49.6	58.1	-	19.1		0	2.5			67.5
28-Nov-17	13:45	80.2	70.3	63.9	60.5	53.9	51.8	51.3	50.9	49.9	59.3	100	19		0	1.944444			90
28-Nov-17	14:00	73.2	65.7	61.6	59.8	55.8	54.2	53.8	52.7	52.2	57.7	-	18.5		0	1.111111			180
28-Nov-17	14:15	72	63.6	60	58.3	55.2	53.4	53	52.1	52	56.5	100	18.9		0	1.111111			157.5
28-Nov-17	14:30	83.8	76.5	65	61	55.8	53.9	53.3	52.4	50.8	62.9	-	18.7		0	1.111111			112.5
28-Nov-17	14:45	73.2	69.1	63.9	61.3	58.3	56.3	54.9	53.2	52.4	60	100	18.6		0	1.111111			112.5
28-Nov-17	15:00	72.5	64.2	61.3	59.3	55.8	54.2	53.9	53.1	52.4	57.2	-	18.6		0	1.666667			135
28-Nov-17	15:15	79.9	67.2	63.1	61	56.5	54.7	54.3	53.5	52.7	59.2	100	18.9		0	1.111111			135
28-Nov-17	15:30	73.7	66	61.6	59.9	56.2	53.9	53.3	52.4	52	58	-	18.9		0	0.555556			360
28-Nov-17	15:45	76.7	67.2	62.1	60.5	56.2	53.4	52.8	51.6	49.2	58.3	100	19		0	0.555556			315
28-Nov-17	16:00	80	67.4	61.7	59.7	55.7	53.2	52.5	51.4	50.8	58	-	18.3		0	1.944444			135
28-Nov-17	16:15	78.4	64.8	61.8	60	54.1	50.7	50	48.7	47.8	56.8	100	18.3		0	2.5			135
28-Nov-17	16:30	79.7	67.8	61.9	59.3	52.7	49.1	48	46.5	45.3	57	-	18.5		0	1.666667			180
28-Nov-17	16:45	85.4	70.1	61.6	59.4	52.4	48.9	48	46.4	45.1	58.9	100	18.5		0	1.111111			135
28-Nov-17	17:00	75.7	70.4	62.6	60.2	53.1	48.6	47.8	46.5	45.5	57.9	-	18.9		0	1.666667			157.5
28-Nov-17	17:15	83.6	66.6	61.5	59.4	53	49	48	46.4	45.6	59.2	100	18.4		0	1.666667			157.5
28-Nov-17	17:30	76.2	65.2	61	58.8	53	48.8	47.7	46.2	44.8	56.2	-	18.1		0	1.944444			180
28-Nov-17	17:45	76.8	65.4	61.9	59.3	52.6	48.7	47.5	45.7	44.4	56.2	100	18.2		0	1.944444			180
28-Nov-17	18:00	79.9	64.6	60.7	58.2	52.2	47.5	46.6	45	43	55.7	-	18.2		0	1.666667			157.5
28-Nov-17	18:15	73	63.5	59.2	56.7	50.5	46	45	43.1	41.5	53.7	100	18.1		0	1.666667			135
28-Nov-17	18:30	75.4	63.9	59.9	57.8	51.2	46.8	46.1	45	43.1	55	-	18.4		0	1.111111			90
28-Nov-17	18:45	72.3	64.7	60.9	58.4	51.6	45.6	44.6	43.3	41.5	55.2	100	18.4		0	1.666667			90
28-Nov-17	19:00	81.4	64.3	61.2	59	52.2	47.1	45.9	44.3	42.7	57.2	-	18.5		0	1.111111			112.5
28-Nov-17	19:15	69.5	61.1	58.3	56.4	51.8	50	49.6	49	48.3	53.7	100	18.6		0	0.555556			135
28-Nov-17	19:30	81.5	71.1	63	61	53.8	50.7	50.2	49.3	48.7	59.3	-	18.4		0	2.5			180
28-Nov-17	19:45	68.1	62.6	57.5	55.6	51.5	49.7	49.3	48.7	48.3	53.6	100	17.9		0	3.611111			180
28-Nov-17	20:00	75.9	67.2	60.5	58.2	51.9	49.4	49	48.1	47.3	56.1	-	18.3		0	2.5			202.5
28-Nov-17	20:15	65.8	61.3	58.2	56.7	53.1	49.7	49.2	48.3	47.9	54.2	100	18.5		0	2.5			180
28-Nov-17	20:30	71.5	64.1	60.2	57.9	53.4	51.5	51.1	50.2	49.5	55.5	-	18.3		0	3.611111			180
28-Nov-17	20:45	68.4	64.3	60.4	58.5	53.9	51.6	51.1	50.2	49.4	55.8	100	18.5		0	3.611111			180
28-Nov-17	21:00	67.8	62.2	58.7	57	53.7	50.8	50.2	49.3	48.4	54.8	-	18.8		0	3.055556			202.5
28-Nov-17	21:15	69.4	63.8	59.2	56.7	52.5	50.4	50.1	49.2	48.3	54.7	100	19.3		0	3.055556			180
28-Nov-17	21:30	69.9	63.7	58.4	56.6	53	50.5	50.1	49.3	49.1	54.7	-	19.1		0	4.166667			180
28-Nov-17	21:45	64.2	61.1	58.7	57.4	53.6	50.9	50.3	49.4	49.1	54.7	100	18.9		0	4.166667			180
28-Nov-17	22:00	75.2	60.6	56.5	55.1	52.6	50.7	50.2	49.6	49.2	54.3	-	18.8		0	5.277778			180
28-Nov-17	22:15	65.2	61.5	57.8	56.6	54.2	51.1	50.5	49.8	49.1	54.8	100	19		0	4.722222			180
28-Nov-17	22:30	77.2	64.4	58.4	56.2	52.7	51	50.6	50	49.5	55.4	-	19		0	4.722222			180
28-Nov-17	22:45	69.5	62	57.1	54.8	52	50.3	50.1	49.3	49.2	53.6	100	19.4		0	4.722222			180
28-Nov-17	23:00	60.9	56.6	54.4	53.8	52.1	50.6	50.2	49.8	49.2	52.4	-	19.9		0	4.166667			180
28-Nov-17	23:15	73.3	60	55.8	54.9	53.1	50.8	50.3	49.5	49.2	54.1	100	19.8		0	4.722222			180
28-Nov-17	23:30	62.4	57.6	54	53.3	51.4	50.1	50	49.1	48.9	51.9	100	19.8		0.2	4.166667			180
28-Nov-17	23:45	64.5	61.3	57.4	55.7	53.6	51.8	51.3	50.6	50	54.3	100	19.9		0	4.166667			180
29-Nov-17	0:00	68.2	58.9	54.6	53.3	51.6	50.2	50	49.2	49	52.3	100	20.1		0	4.166667			180
29-Nov-17	0:15	62.1	57.8	55.7	54.9	52.6	50.2	49.8	49.1	48.9	53.1	100	20.3		0	5.277778			180
29-Nov-17	0:30	61.5	54.8	53.7	53.2	51.5	50.2	50	49.1	49.1	51.8	100	20.2		0	5.277778			180
29-Nov-17	0:45	66.7	58	55.7	55	52.7	50.3	50.1	49.3	49.1	53.3	100	20.1		0	5.555556			180
29-Nov-17	1:00	67	62	54.1	53.1	51.2	50	49.5	49	48.8	52.6	100	20.2		0	6.666667			180
29-Nov-17	1:15	60	57.7	55.6	54.9	52.7	50.1	49.6	49	48.7	53.1	100	20.3		0	6.111111			180
29-Nov-17	1:30	67.7	57.1	53.4	52.8	51.1	49.7	49.3	48.9	48.4	51.7	100	20.3		0	6.111111			180
29-Nov-17	1:45	63.3	55.7	54.8	54.6	52.4	50.1	49.7	49.1	48.8	52.7	100	20.3		0	5.555556			180
29-Nov-17	2:00	66.1	56.2	53	52.7	51.2	50	49.6	49.1	48.9	51.5	100	20.5		0	5.277778			180
29-Nov-17	2:15	66.1	55.8	54.9	54.6	52.8	50.3	50	49.2	48.9	52.9	100	20.5		0	6.111111			180
29-Nov-17	2:30	66.5	55.6	53.4	52.8	51.2	49.9	49.4	49	48.3	51.5	100	20.4		0	4.722222			180
29-Nov-17	2:45	57.9	53.7	52.6	51.9	50.4	49.2	49	48.2	47.8	50.6	100	20.5		0	5.277778			180
29-Nov-17	3:00	58.6	55.8	54.9	54.7	52.8	49.8	49.3	48.5	47.9	52.9	100	20.5		0	5.277778			180
29-Nov-17	3:15	63.4	58.3	53.5	52.6	51	50	49.5	49	48.6	51.6	100	20.6		0	4.722222			180
29-Nov-17	3:30	59.3	57.2	55.8	55.2	52.8	50.2	50	49.1	48.9	53.2	100	20.6		0	4.722222			180
29-Nov-17	3:45	57.8	54.7	53.4	52.8	51.3	50	49.7	49.1	48.7	51.5	100	20.8		0	4.166667			180

<colgroup><col><col span="19"></colgroup><tbody>
</tbody>

 

[tjrobo19]

Example chart sheets I need to generate per day
https://drive.google.com/file/d/14W4-Sm_HtG9Zfmv7JNOKkeb6u82nYVm9/view?usp=sharing