Forum Discussion
Excel XY scatter plots are inaccurate
This is similar to https://techcommunity.microsoft.com/t5/excel/scatter-chart-plots-wrongly-if-blank-cells-exist-in-input-range/m-p/1337190 , except plotting my data with blank cells works fine. ...
Not sure that I fully understand what you are doing, but when I look at the data selected for the orange dots ("test") I see that the header is a single cell (the red box) with all the data below it (the blue box).
However, the data for "val sub T1" is set-up differently. The header spans all the way down to sequence 663 and the data starts at sequence 664. That's causing the shift in the chart.
Fix that and both plots will overlap. The fact that "val sub T1" contains blank cells and "test" contains a formula referring to a blank cell makes no difference.