This week's Excel Optical Illusion is called Kaleidoscope Motion and was originally created by Peter van der Helm in 2007. I modeled mine after Michael Bach's version, but with a twist:

The red cogwheel rotates, but does it rotate smoothely? Physically, the rotation is perfectly smooth as you can confirm by making parts of the arrangement transparent. However it seemingly jolts ever so often.
To my eye it looks as if the blue inner cog jumps to the left periodically. While I included the outer cog, I decided to color it white to enhance the effect.
My Excel version of the illusion uses simple shapes that are grouped and rotated via VBA.
As always, the workbook animation is much, much better than the GIF.
Here is the file.
If you like my blog, please be sure to sign-up for the new Excel Hero Newsletter. Subscribers receive all of my articles AND extra Excel Hero tips.
Why do I share these optical illusions? The techniques that are used to make them, when mastered, can be used in many other Excel projects, in charting, formula crafting, and formatting. Learn them. They will aid you on your journey to become an Excel Hero.
Here is a list of other Excel Optical Illusions here at Excel Hero:
- Enigma
And here's a list of other animated charts on Excel Hero:
- Excel, A Presentation Platform (Number Spiral)
- Lilac Chaser (Optical Illusion)
- Stereokinetic (Optical Illusion)
- Illusory Contours (Optical Illusion)
- Breathing Square (Optical Illusion)
- Enigma (Optical Illusion)
- Two Sinusoids (Optical Illusion)
- Perpetual Collisions (Optical Illusion)
- Freezing Rotation (Optical Illusion)
- Reverse Spoke Illusion (Optical Illusion)
- Stepping Feet Radial Illusion (Optical Illusion)
- Swimming Fish (Optical Illusion)
- Mutually Interfering Shapes (Optical Illusion) - Kaleidoscope Motion (Optical Illusion)
If you liked this article, please share it!

Leave a comment