Dynamic charting when data table is horizontal instead of vertical

[Hawk11ns]

I've come across various tutorials on dynamic charts online; however, they all are in regards to data tables where the time series is vertical (i.e. in column A). Because EXCEL limits the number of Series we can have, and since I am working to chart hourly data that spans years, I've recorded my time data horizontally (i.e. in row 1). The end goal, is to have a sheet where users enter/select a start/stop date and a chart will change scope to fit the period. Below is a small piece of the data starting with "DATE:" in cell B1 - note the data spans through column PEY and the x-axis doesn't need to display any values. Any guidance here is very much appreciated, thanks!

DATE:	10/1/2020​	10/1/2020​	10/1/2020​	10/1/2020​	10/1/2020​	10/1/2020​	10/1/2020​	10/1/2020​	10/1/2020​	10/1/2020​	10/1/2020​	10/1/2020​	10/1/2020​	10/1/2020​	10/1/2020​	10/1/2020​	10/1/2020​	10/1/2020​	10/1/2020​	10/1/2020​	10/1/2020​	10/1/2020​	10/1/2020​	10/1/2020​	10/2/2020​	10/2/2020​	10/2/2020​	10/2/2020​	10/2/2020​	10/2/2020​	10/2/2020​	10/2/2020​	10/2/2020​	10/2/2020​	10/2/2020​	10/2/2020​	10/2/2020​	10/2/2020​	10/2/2020​	10/2/2020​	10/2/2020​	10/2/2020​	10/2/2020​	10/2/2020​	10/2/2020​	10/2/2020​	10/2/2020​	10/2/2020​	10/3/2020​	10/3/2020​	10/3/2020​	10/3/2020​	10/3/2020​	10/3/2020​	10/3/2020​	10/3/2020​	10/3/2020​	10/3/2020​	10/3/2020​	10/3/2020​	10/3/2020​	10/3/2020​	10/3/2020​	10/3/2020​	10/3/2020​	10/3/2020​	10/3/2020​	10/3/2020​	10/3/2020​	10/3/2020​	10/3/2020​	10/3/2020​	10/4/2020​	10/4/2020​	10/4/2020​	10/4/2020​	10/4/2020​	10/4/2020​	10/4/2020​	10/4/2020​	10/4/2020​	10/4/2020​	10/4/2020​	10/4/2020​	10/4/2020​	10/4/2020​	10/4/2020​	10/4/2020​	10/4/2020​	10/4/2020​	10/4/2020​	10/4/2020​	10/4/2020​	10/4/2020​	10/4/2020​	10/4/2020​
HE:	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24
OBLIGATION	50.23	44.82	40.92	38.43	36.65	37.48	40.03	40.88	41.79	44.88	50.81	58.18	66.25	73.69	79.76	87.11	95.09	98.17	94.87	91.43	87.07	77.39	66.43	54.64	49.14	43.87	40.37	37.95	36.39	37.31	39.94	40.81	41.93	45.31	51.35	58.73	66.88	74.79	80.72	88.70	96.56	99.42	96.45	92.62	88.38	79.73	68.87	56.61	51.17	45.94	42.14	39.44	37.77	38.55	40.88	42.08	43.22	46.83	53.15	61.61	70.51	78.43	83.82	91.53	99.10	101.59	97.46	93.14	89.13	80.82	70.91	60.01	53.56	47.83	44.18	41.12	38.69	37.74	37.69	37.97	40.15	45.25	52.58	61.40	70.34	76.44	81.30	87.79	94.38	95.65	91.29	87.93	84.44	76.76	68.33	57.91
HEDGE	4.40	4.40	4.40	4.40	4.40	4.40	50.30	50.30	50.30	50.30	50.30	50.30	50.30	50.30	50.30	50.30	50.30	50.30	50.30	50.30	50.30	50.30	4.40	4.40	4.40	4.40	4.40	4.40	4.40	4.40	50.30	50.30	50.30	50.30	50.30	50.30	50.30	50.30	50.30	50.30	50.30	50.30	50.30	50.30	50.30	50.30	4.40	4.40	4.40	4.40	4.40	4.40	4.40	4.40	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	4.40	4.40	4.40	4.40	4.40	4.40	4.40	4.40	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	4.40	4.40