As promised last week, the Smith Chart will be published in a few hours. It is one of the most demanding charts I have ever created, and it is just about ready. Please look for it Monday.
In the meantime, this week’s Excel Optical Illusion is called Swimming Fish, and was originally created by Emily Knight and Arthur Shapiro. It was a 2007 Finalist in the Best Illusion of the Year Contest hosted by the Vision Sciences Society.
Are the fish bobbing up and down? I can assure you that they do not move.
My Excel version of this illusion is much smoother than the animated GIF above can reproduce. It includes an option to remove the moving background, which eliminates the illusion.
This is an XY Scatter chart with a little VBA for the animation. Pretty straightforward but I like how the background lines were made to seem infinite when there are only six of them in actual fact.
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:
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)