Daniel's XL Toolbox - Spread Scatter

Spreading a scatter plot is accomplished by changing the values in the cells for the X axis so that the data points are spread out along the X axis. You normally do not see the effect, because the number formatting in those cells is adjusted to not show any decimals. But if you select a cell and look in the formula bar, you will see that it is actually not a whole number.


This is a companion discussion topic for the original entry at https://www.xltoolbox.net/spreadscatter.html

I’m interested in the algorithm used to spread out the datapoints. Where can I learn more?

The algorithm resides in the Module_SpreadScatter module, which is part of the ‘legacy’ Toolbox.

https://sourceforge.net/p/xltoolbox/code/ci/master/tree/Module_SpreadScatter.bas

The current Github repository does not have this module in plain text, because the entire .xlam file was checked in.