That is far too labour intensive and should be able to be completely automated.
First thing is you need to measure the peak and off-peak energy use separately. This is easy with Utility Meter Tariffs and an automation. See: How to use Utility Meter Tariffs to conditionally measure things
For graphing this in HA, ApexCharts would probably be your best bet. Though the Sankey chart may also be another option.