Did you end up finding a solution to this, a way to get Apexcharts working with the Energy Date Picker card and/or Energy card collection key?
Edit–looks like it may have been done in Use native energy-date-selection card to control custom Apexcharts / Plotly graphs, although not trivial to implement. And also in Energy Custom Graph. A custom card to use Home Assistants internal EChart library with more flexibility