User Profile
just_no_
Copper Contributor
Joined Jun 29, 2021
User Widgets
Recent Discussions
[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.
