[SOLVED] Time series data of two data sets ("buy" and "s") with independent X series values

Scatter charts work correctly, but bar charts do NOT. 

Let me explain. I have 1 set of data with its own X series values. We'll call it DATA 1 with X Series 1. 

I have a second set of data with its own X series values. We'll call it DATA 2 with X Series 2. 

Here:

I can make this work with a scatter plot:

But I actually want bars instead of dots. When I try to make them clustered columns, the data becomes WRONG:

On the other hand, I can make one of the data series a cluster column, and the data remains correct. But this is non-ideal. I want both to be column charts. 

Is there a better way to do this? I need both to be bars, they need to share the same date-based primary axis, and the data need to be correctly depicted on the chart exactly, with no weird erroneous time shifting or missing data. But when I make them cluster column, the data being presented on the chart isn't correct, and doesn't function correctly based on my needs.