Creating forward looking charts

You could possibly use Apexcharts and if the data is not (yet) correct for it, since you are at the root of it you may be able to adapt it too.
You can share something here or go to the vast post on that card
RomRider/apexcharts-card: :chart_with_upwards_trend: A Lovelace card to display advanced graphs and charts based on ApexChartsJS for Home Assistant (github.com)
ApexCharts card - A highly customizable graph card - Share your Projects! / Dashboards & Frontend - Home Assistant Community (home-assistant.io)

Alternative is plotly
Plotly interactive Graph Card - Share your Projects! / Dashboards & Frontend - Home Assistant Community (home-assistant.io)