Monitoring Electricity and Solar Energy data into a graph

[bullit_nl]

Hi,
I would like to create different graphs and later on dashboards in Excel from the data I have from energy usage and solar energy.
For example the two graphs should look like this examples:
- Solar Consumption
- Grid
- Surplus

The data I have available punt in one worksheet:
T1/T2 = for different tariffs
L1/L2/L3 = 3 phases

date/time

Data from Energy Meter

Data from Energy Meter

Data from Energy Meter

Data from Energy Meter

Data from Energy Meter

Data from Energy Meter

Data from Energy Meter

Data from circuit breaker box approved kWh Meter

Data from circuit breaker box approved kWh Meter

Data from circuit breaker box approved kWh Meter

Data from circuit breaker box approved kWh Meter

Data from circuit breaker box approved kWh Meter

date/time

Import T1 kWh

Import T2 kWh

Export T1 kWh

Export T2 kWh

L1 max W

L2 max W

L3 max W

Import kWh

Export kWh

L1 max W

L2 max W

L3 max W

Any help would be highly appreciated.