+'&title='+encodeURIComponent(document.title)+'&overview='+encodeURIComponent(document.title)+'&urllanguage=en&urlaffiliate=32003&encoding=UTF-8&urlpicture=http://www.viadeo.com/v_img14/shareit/viadeoflower.gif')
Just lean forward toward your monitor and back again to see the luminance optical illusion.
This is a Radar chart with radial gradients for the series and the plot area. The file is an .xls and so will work (sort of) for older versions. Radial gradients are new so versions previous to Excel 2007 will render the gradients as a rectangle, with muted colors, but interestingly the illusion still presents!
Here's the file.
If you like my work, 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
If you liked this article, please share it!
Don't do this at work. You'll look really silly!
This is very cool.
I like the effect in Firefox of scrolling this picture up/down the screen
It looks like a spider walking up/down
I don't have smooth scrolling enabled
I like your formula =CHOOSE(1+MOD(ROW(INDIRECT("1!1:" &50)),5),2,0,0,2,2)
Clever way to generate a repeating pattern. You know all the cool hacks...where do you pick up this stuff from?
I'm often as amazed by your methods as I am from the actual charts. Perhaps you could highlight the workings of such formulas in each post, along with providing the chart? If time permits, of course...
I believe examining these formula is our homework..
@Daniel.
I would not use Choose. I just stick to Index. Are there any specific advantages of using choose over Index
@sam -
Normally, I'd agree, but in this case INDEX would not work! Try it. Let me know if you get different results.
Regards,
Daniel Ferry
excelhero.com
Another nice illusion, i like these radar charts examples.
For the formula that produces the rays maybe also try: ={0,0,2,2,2}*{1;1;1;1;1;1;1;1;1;1}
CHOOSE works fine, it's annoying that INDEX doesn't work as expected with arrays, there are also other alternatives with LOOKUP and MMULT.
For the integer array other options to ROW(INDIRECT(...)) are:
=ROW(1!2:51)-ROW(1!1:1)
=ROW(OFFSET(1!A:A,,,50))
which are using relative references so they are not changed by sheet editing and would allow for the sheetname to change, the first needs to be defined with A1 active.
Keep up the great work! Lori