Excel Optical Illusions #9

| 5 Comments | 0 TrackBacks

This week's Excel Optical Illusion is called the Hering Illusion.

So are the red squares, square? Click the Background check box to find out?

Like some others the intensity of this illusion depends on your distance from the screen. Get closer or farther and see what happens...

This is not a chart. I'm simply formatting the worksheet for the illusion. More to come.

Reblog this post [with Zemanta]
If you liked this article, please share it!

Your Ad Here

No TrackBacks

TrackBack URL: http://www.excelhero.com/cgi-bin/mt/mt-tb.cgi/34


Very nice indeed. I closed my eyes - and yes - its still twitching! Keine mehr lorem ipsum, ich liebe der chicken. Schlaffen. Guten nicht.

I'm about to have a fit also
But Well Done

It may be handy to call out a few techniques used in these workbooks or give some cursory explanation of the mechanics. Working through some of the workbooks can be difficult unless you already have a sense of what is going on. E.g. this workbook uses conditional formatting for the background, but unless you click on the cell and hit conditional formatting you would not know. (Or is there some way to identify conditional formatting in a workbook without knowing ahead of time which cells already have it?) Likewise, you use the REPT() function to conditionally display text. This is something you explain well in a comment to the "I Heart IF" post, but I was scratching my head a bit trying to understand what REPT() was used for in this context. Usually I see it used to repeat stuff rather than as a substitute for an if function. I am by no means complaining, these workbooks are great; just trying to get my head around them. On the issue of reverse engineering, is there a way to know the chart type of an existing chart aside from clicking on stuff and trying to figure out the context based on the available options? I suppose this could be done by extracting the relevant property in VBA, but is there another method?

Not wanting to be obnoxious, but: Even if it's red, it's "Hering Illusion", not "Herring" ;-).

Best, Michael.


You are absolutely right. Thanks for catching that - it's now corrected.

I'm honored that YOU are following my replicas of the illusions from your terrific site:



Daniel Ferry

Leave a comment

About this Entry

This page contains a single entry by Daniel Ferry published on April 16, 2010 12:20 PM.

Excel Location Mapping was the previous entry in this blog.

Excel Optical Illusions #10 is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.