Creating chart in VBA? Chart based on user selected date?

Hi all,

I was hoping I could get some assistance on creating a fairly basic line chart. I considered posting this in the charting section, but it might be that this is better solved using VBA?

I created an additional sheet just to show a bit better what my problem is. My "raw data" is in a table in column J-O. I tried creating a chart using just this table, but it's a mess.

In cells C3&4-F3&4 shows how Excel would like to read my data in order to print a line chart with paired data.

Basically, the first data point is always 0 at 09:30 and the final data point is always at 16:00 with a corresponding price (see table).

Maybe there is a smarter way to format/set up my data such that I can create charts directly from my tables?

Chart.png

Finally, I was thinking that it would be great if I could have the functionality of refreshing/drawing the chart by selecting the corresponding date. I could select the cell with date and then run the macro.

Chart2.png

Maybe this is too involved of a task to be asking here for free, but I figured I could ask.

Thanks in advance for any help!

Best regards,

Elijah