Dynamic charts

[jouri_ph]

Dear excel expert,

I need to create 2 kind of dynamic charts but after hours of work it still doesn't work and I really need some help from an excel professional .
These dynamic charts are for DC-discharge tests for multiple batteries in series.
1 chart is for the total voltage and current of all the batteries combined and the other one is a chart of only the voltage of each individual battery.

For the total voltage and current chart the dynamic range has to be the total time of discharge and of the amount of voltage and current.
Raw data from total voltage and current (0-10 is time in seconds):

time	voltage		time	current
0​	535​		0​	0​
1​	535​		1​	0​
2​	535​		2​	0​
3​	535​		3​	0​
4​	535​		4​	0​
5​	535​		5​	0​
6​	535​		6​	-1​
7​	535​		7​	-1​
8​	535​		8​	-1​
9​	535​		9​	-1​
10​	535​		10​	-1​

For the individual battery chart (the hardest) there has to be a dynamic range for the time, total batteries and the voltage of the individual batteries:

	(not needed)	(not needed)	(not needed)	batt. number	batt. number	batt. number	batt. number	batt. number	batt. number	batt. number	batt. number	batt. number	batt. number
Time(HMS)	Voltage(V)	Current(A)	Discharged Capacity(AH)	1	2	3	4	5	6	7	8	9	10
13:17:08	538.10	12.13	0.00	13.440	13.430	13.440	13.440	13.440	13.480	13.460	13.450	13.460	13.440
13:18:08	487.50	12.13	0.30	12.060	12.220	12.180	12.180	12.130	12.180	12.210	12.110	12.160	12.140
13:19:08	489.50	12.13	0.70	12.100	12.270	12.240	12.230	12.170	12.230	12.260	12.160	12.210	12.180
13:20:08	490.10	12.13	1.10	12.110	12.290	12.260	12.250	12.190	12.250	12.280	12.170	12.230	12.200
13:21:08	490.30	12.13	1.50	12.100	12.300	12.260	12.260	12.200	12.260	12.290	12.180	12.240	12.210
13:22:08	490.20	12.13	1.90	12.090	12.300	12.260	12.260	12.190	12.250	12.290	12.180	12.240	12.210
13:23:08	490.00	12.13	2.30	12.080	12.290	12.260	12.260	12.190	12.250	12.290	12.170	12.230	12.200
13:24:08	489.60	12.13	2.70	12.060	12.290	12.260	12.250	12.180	12.240	12.290	12.160	12.220	12.190
13:25:08	489.10	12.13	3.10	12.040	12.280	12.250	12.240	12.170	12.240	12.280	12.150	12.210	12.180
13:26:08	488.70	12.13	3.50	12.020	12.260	12.240	12.230	12.150	12.220	12.270	12.130	12.210	12.170
13:27:08	488.10	12.13	3.90	12.000	12.260	12.230	12.220	12.140	12.210	12.260	12.120	12.190	12.150
13:28:08	487.50	12.13	4.40	11.980	12.250	12.210	12.210	12.130	12.200	12.250	12.100	12.180	12.130
13:29:08	486.80	12.13	4.80	11.960	12.230	12.200	12.190	12.110	12.180	12.240	12.080	12.170	12.120
13:30:08	486.10	12.13	5.20	11.930	12.210	12.190	12.180	12.090	12.170	12.220	12.070	12.150	12.110
13:31:08	485.40	12.13	5.60	11.910	12.190	12.160	12.160	12.070	12.140	12.210	12.050	12.130	12.090
13:32:08	484.60	12.13	6.00	11.880	12.180	12.150	12.140	12.050	12.130	12.190	12.030	12.110	12.070
13:33:08	483.80	12.13	6.40	11.860	12.160	12.130	12.130	12.030	12.110	12.170	12.000	12.090	12.040
13:34:08	483.10	12.13	6.80	11.830	12.140	12.110	12.110	12.000	12.090	12.150	11.980	12.080	12.020
13:35:08	482.10	12.13	7.20	11.810	12.120	12.090	12.080	11.980	12.060	12.130	11.950	12.060	12.000
13:36:08	481.20	12.13	7.60	11.780	12.100	12.070	12.070	11.960	12.040	12.110	11.930	12.030	11.980
13:37:08	480.20	12.13	8.00	11.750	12.080	12.050	12.050	11.930	12.020	12.090	11.910	12.020	11.950
13:38:08	479.20	12.13	8.50	11.730	12.060	12.030	12.030	11.910	12.000	12.070	11.890	11.990	11.930
13:39:08	478.20	12.13	8.90	11.690	12.040	12.000	12.000	11.890	11.970	12.050	11.860	11.970	11.910
13:40:08	476.90	12.13	9.30	11.660	12.010	11.980	11.980	11.860	11.950	12.030	11.840	11.950	11.880
13:41:08	473.80	12.13	9.70	11.630	11.990	11.950	11.950	11.840	11.920	12.000	11.810	11.920	11.850
13:42:08	472.80	12.13	10.10	11.600	11.970	11.930	11.930	11.810	11.900	11.980	11.790	11.900	11.820
13:43:08	471.70	12.13	10.50	11.580	11.940	11.900	11.900	11.790	11.870	11.950	11.760	11.870	11.790
13:44:08	470.50	12.13	11.00	11.540	11.910	11.860	11.870	11.760	11.840	11.930	11.740	11.840	11.770
13:45:08	469.40	12.13	11.40	11.510	11.890	11.840	11.850	11.740	11.810	11.900	11.710	11.820	11.740
13:46:08	468.10	12.13	11.80	11.470	11.860	11.800	11.820	11.710	11.780	11.870	11.690	11.790	11.720
13:47:08	466.90	12.13	12.20	11.440	11.840	11.770	11.790	11.680	11.750	11.850	11.650	11.760	11.680

I've created a wonderful (for my standards) excel document/report where I can load these files directly from the files from the measuring devices including a database off the clients information.
And this is the only thing that's holding me back with finishing the entire document/report.

I hope i'm not asking for a lot but whoever can help me with this will be a hero in my book because it's already been several months of trial and error.