The reason this works is because the distance between each category is 1. That’s how Excel translates category spacing for the scatter plot – side note: remember scatter plot needs numbers for X and Y – if you leave X empty, Excel is nice enough to fill it with 1, 2, 3, etc for each category. – Doesn’t work for Y but it does for X). 3D Scatter plot in Excel. Thread starter Guest. I do have an Excel add-in that produces simple scatterplots in 3D and allows you to rotate along any dimension. I use this because some of my students find it difficult to "visualize" 3D perceptual maps from the 2D projections.
Apr 08, 2018 · 4. Linearity The relationship between the two variables should be linear. This assumption can be checked by generating a scatter plot. 5. Homoscedasticity —The variability in scores for variable X should be similar at all values of variable Y. This assumption can be checked by generating a scatter plot.