This week's Excel Optical Illusion is called The Freezing Rotation.

This animated GIF does not do justice - the workbook animation is much smoother.
As Michale Bach describes this illusion in the his page that inspired me...
... you see (1) an inner rotating part (the text) placed on (2) a rotating disk made up of coloured dots. The outer disk does not rotate continuously, but 'swings' back and forth. What is the motion of the central text? Is is a smooth rotation?
Or doesn't it rather 'freeze' now and then, depending on the outer rotation?
My Excel version is a collection of shapes that are being animated by VBA, sporting easing. The VBA is dead simple so please download the file to see how it is done.
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)
If you liked this article, please share it!

Hey, this is Eric. Saw your fine illusions collection. The inner rotating part here seems to "freeze" uniformly.