Energy consumption - looking for a chart which allows consumption per RANK (EPEX Spot Ranks)

Dear Community,
I tried to find a way to build a chart that tells me the following:

  • on the x-axis you find the ranks 0 to 23 like you get it from EPEX
  • on the y-axis you see the spreading - percentage or kWh

I don’t want to see WHEN energy is consumed, but if it was consumed within a cheap time.
The EPEX-rank is rather perfect for that.
To be able to control that over time, one could see, if your tibber, awattar or any other SPOT-tariff helps you to consume energy when it is cheap.

Unfortunately I don’t have any possibility to have my own photovoltaics.
I tried by myself and googled it, but was not able to build it by my own.
I hope someone is inspired by my idea and helps me out.

I made it within calc with some exported data. But within HA would be much more time saving.
RANK-example