Allowing for scratches, and dynamics, with proper array formulation, each ball can be made to move as it should, in theory. It's a project I'm working on. 15 balls and a cue ball times 2 makes 2 games simultaneously. Adequate for a pool shark on a holiday break.
Create the above graphic using this series:
=SERIES(,Data!$F$7:$F$1447,Data!$G$7:$G$1447,1)
or this one:
=SERIES(,Data!$X$7:$X$1446,Data!$Y$7:$Y$1446,1)
Final image;
How to Create a Skewed Spheroids Pattern in Microsoft Excel Picture 3
Part 4 of 4:
Helpful Guidance
Make use of helper articles when proceeding through this tutorial:
See the article How to Create a Spirallic Spin Particle Path or Necklace Form or Spherical Border for a list of articles related to Excel, Geometric and/or Trigonometric Art, Charting/Diagramming and Algebraic Formulation.
For more art charts and graphs, you might also want to click on Category:Microsoft Excel Imagery, Category:Mathematics, Category:Spreadsheets or Category:Graphics to view many Excel worksheets and charts where Trigonometry, Geometry and Calculus have been turned into Art, or simply click on the category as appears in the upper right white portion of this page, or at the bottom left of the page.