adjusting time based horizontal axis on stacked bar chart

[Prevost]

Hi There. I have 19760 date & time values in column A (it starts in June and each row is incremented by 1 minute). Columns B, C, D, and E have energy uses for each minute for different pieces of equipment. I want to create a stacked bar chart showing the total energy used for each minute but in the stacked format so it shows how much each is contributing.

I had to change the horizontal axis type to text axis to show all the data, but now the scale is off and it is incremented in a non uniform amount and isn't logical. I would ideally like to increment it in 12 hours.

Does anyone know how to format the axis that way? I can only seem to format a date axis using the X-Y scatter chart types...

Any help is appreciated!

Thanks