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

%3CLINGO-SUB%20id%3D%22lingo-sub-2498923%22%20slang%3D%22en-US%22%3E%5BSOLVED%5D%20Time%20series%20data%20of%20two%20data%20sets%20(%22buy%22%20and%20%22s%22)%20with%20independent%20X%20series%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2498923%22%20slang%3D%22en-US%22%3E%3CP%3EScatter%20charts%20work%20correctly%2C%20but%20bar%20charts%20do%20NOT.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%20me%20explain.%20I%20have%201%20set%20of%20data%20with%20its%20own%20X%20series%20values.%20We'll%20call%20it%20DATA%201%20with%20X%20Series%201.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20second%20set%20of%20data%20with%20its%20own%20X%20series%20values.%20We'll%20call%20it%20DATA%202%20with%20X%20Series%202.%26nbsp%3B%3C%2FP%3E%3CP%3EHere%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22just_no__0-1624997839066.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F292402iD45A00211E466693%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22just_no__0-1624997839066.png%22%20alt%3D%22just_no__0-1624997839066.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20can%20make%20this%20work%20with%20a%20scatter%20plot%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22just_no__2-1624997917309.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F292404iD7C436054B917A82%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22just_no__2-1624997917309.png%22%20alt%3D%22just_no__2-1624997917309.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EBut%20I%20actually%20want%20bars%20instead%20of%20dots.%20When%20I%20try%20to%20make%20them%20clustered%20columns%2C%20the%20data%20becomes%20WRONG%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22just_no__3-1624998062614.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F292405i9843BD80A337A121%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22just_no__3-1624998062614.png%22%20alt%3D%22just_no__3-1624998062614.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EOn%20the%20other%20hand%2C%20I%20can%20make%20one%20of%20the%20data%20series%20a%20cluster%20column%2C%20and%20the%20data%20remains%20correct.%20But%20this%20is%20non-ideal.%20I%20want%20both%20to%20be%20column%20charts.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22just_no__4-1624998182351.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F292407iF20EE598DEA5914F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22just_no__4-1624998182351.png%22%20alt%3D%22just_no__4-1624998182351.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIs%20there%20a%20better%20way%20to%20do%20this%3F%20I%20need%20both%20to%20be%20bars%2C%20they%20need%20to%20share%20the%20same%20date-based%20primary%20axis%2C%20and%20the%20data%20need%20to%20be%20correctly%20depicted%20on%20the%20chart%20exactly%2C%20with%20no%20weird%20erroneous%20time%20shifting%20or%20missing%20data.%20But%20when%20I%20make%20them%20cluster%20column%2C%20the%20data%20being%20presented%20on%20the%20chart%20isn't%20correct%2C%20and%20doesn't%20function%20correctly%20based%20on%20my%20needs.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2498923%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2503276%22%20slang%3D%22en-US%22%3ERe%3A%20%5BSOLVED%5D%20Time%20series%20data%20of%20two%20data%20sets%20(%22buy%22%20and%20%22s%22)%20with%20independent%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2503276%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1091336%22%20target%3D%22_blank%22%3E%40just_no_%3C%2FA%3E%26nbsp%3B%2C%20see%20attached%20workaround%20solution.%20The%20attached%20file%20describes%20the%20steps.%3C%2FP%3E%3CP%3E(May%20mark%20it%20as%20solution%20if%20it%20helps.)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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:

just_no__0-1624997839066.png

I can make this work with a scatter plot:

just_no__2-1624997917309.png

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

just_no__3-1624998062614.png

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. 

just_no__4-1624998182351.png

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. 

 

 

1 Reply

@just_no_ , see attached workaround solution. The attached file describes the steps.

(May mark it as solution if it helps.)