All articles with 'row()' Tag
![2011 Calendar – Excel Template [Downloads]](https://img.chandoo.org/c/2011-calendar-template-download.png)
Here is a 2011 new year gift to all our readers – a free 2011 calendar template.
(a little secret: just change the year in worksheet “Full” from 2011 to 2012 to get the next year’s calendar. It works all the way up to year 9999)
You can add notes to individual dates or complete month using the excel template very easily. There are 6 different calendar templates in the download file,
* 4 Yearly Calendar Templates with different color schemes.
* 1 Mini Calendar
* 1 Monthly Calendar (prints in 12 pages)
Go ahead and download the calendar files. Enjoy.
Continue »![Highlighting Data Points in Scatter and Line Charts](https://chandoo.org/wp/wp-content/uploads/2010/11/Highlight_Point_Of_Interest.png)
Introducing a method of allowing data points to be interactively highlighted in Excel Scatter / X-Y Charts and Line Charts.
You will see a lot of these style charts in various places where you want to highlight various aspects of the chart to your audience. It is a great technique for complex scientific and engineering charts where you may have hundreds or thousands of points.
Array formula to check if a number is prime [just for fun]
I am math-geek-wannabe, if there ever is such a category. During my 3rd year of graduation I went and purchased the volume 2 of Donald Knuth’s Art of Computer Programming and thus began my love with all things random and prime. I never really became the math-geek I always wanted to, instead I became an insurance expert with tons of passion for data and visualization. But when I get a chance to poke with randomness or numbers, I always lap it up with joy. And that brings us to an interesting array formula trick to check if a number is prime or not.
(assuming the number is in the cell B2) type the below formula and
=IF(MIN(MOD($B$5,ROW(INDIRECT(“2:”&INT(SQRT($B$5))))))=0,”not prime”,”prime”)
hit ctrl+shift+enter and bingo, it tells you if the number is prime or not. Read on to find how it works
Continue »Visualizing Search Terms on Travel Sites – Excel Dashboard
![Visualizing Search Terms on Travel Sites – Excel Dashboard](https://chandoo.org/img/excel-bubble-chart-thumb.png)
Microsoft excel bubble chart based Visualization to understand how various travel sites compete search terms
Continue »