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.
