Author Archive

Looking for a Freelancer for Mobile Development

Posted: February 18, 2016 by MaxFraudy in Others

We are looking for a freelancer who has prior experience in development. Can’t disclose much about the project at this stage. Timelines & enumeration can be discussed and agreed upon mutually.

If you can help or know of someone who can, please do write to  or post a comment here.

It’s no secret that I’m a big fan of beautiful data visualizations. What may not be so obvious is that I’m huge on the KISS (keep it simple stupid) principle when it comes to getting work done. I believe that any moron can complicate things, but it takes a genius to simplify them. (On a separate note, I often recall a quote on life from one of my all-time favorite movies – “It is very simple to be happy, but it is very difficult to be simple”)

Today I’m sharing a simple tip on how you can highlight a data-point on your chart, based on a selection, without using VBA. And the best part is that it can be used for any chart type.

Chart - Highlight Data PointI have data for average precipitation in Delhi by month (for years 2000-2012). I have placed my data in cells A4:B15. Data validation has been put in cell B2 such that it can only take month names from January-December. Now that we are set up, follow these steps: (more…)


Introducing Our New Category… R

Posted: December 1, 2014 by MaxFraudy in R
Tags: ,

You know how learning new things keeps one’s mind agile (or so I’ve heard). Well, following this adage, I’ve recently been spending some time in trying to learn R. I find R to be very different from SAS & SQL or any other language that I have used. It took me quite a while to get used to how data is handled in R.

I’m still a beginner so I don’t see myself posting a lot of ‘useful gyaan‘ on R in near future, however, I believe other beginners may also be facing similar problems as I am. So in line with our mission to ‘make life @work easier‘, I’ll be ‘sharing stuff‘ that could be real help (at least to a novice like me).

The first in line is a cheat sheet for data.table in R (Download data+table+cheat+sheet). This is not my creation but I found it at this place and felt like sharing it. For someone like me, who tends to forget syntax this is a ready reckoner for data.table manipulations. Some examples:

Snapshot of the data.table cheat sheet

Snapshot of the data.table cheat sheet

UntitledWe have earlier discussed how to hide errors in a worksheet in this post. Today I’m going address another similar problem that is very commonly faced. There are various ways to tackle it and there is no right or wrong about it. I’m sharing what I prefer to use (because I find it very simple and easy to implement).

Suppose I have a data table in my dashboard that is referencing to another range. My table has 10 rows (A2:D11) that reference range Z2:AC11. As long as there is data in Z2:AC11, everything is fine.

TableNow suppose that I have data only till row 4. In this case, my table shows 0’s which looks ugly and I’d rather prefer those cells to be blank. How do I solve this problem?

table2 (more…)

Network relationship chart

Posted: November 6, 2014 by MaxFraudy in Excel
Tags: ,

This is great…

User Friendly

I’m a big fan of anyone who can display data in a visual way.  Well today, rather than displaying my own work or giving a “how to” guide, I thought I’d display work from – one of the best sites for Excel help.  This network / stakeholder relationship chart is a work of art and needs no explanation from me.  The full tutorial and example template can be found here:

Hope you find it as inspiring and as useful as I did!

+Alesandra Blakeston


View original post

UntitledToday, I’m sharing a basic but nonetheless a neat trick to make your reports more presentable. I’ll take an example to illustrate my point.

I have Life Expectancy data for various countries for years 2011 and 2012.  The fourth column is calculated using data in B & C columns. The number of rows of data can change, so I have put formula in extra rows. The problem then is that the rows that don’t have data return #DIV! error in column D as below. (more…)

This is a common requirement while creating dashboards. One selects an option and the charts update to show data for that particular selection. It would be very useful if the same chart could show you how that particular selection fares against average or a set benchmark.

Comparison Chart Against AverageLet’s take an example. I have data for a class of students with their subject marks. I make a selection of the student name, his marks for each subject are plotted on a chart. I wish to see how this particular student has performed in each subject as against the class average. This custom chart does just the same, and it can be very very easily created in Excel as below:


In my experience I have come across numerous people who so wish that their charts are ‘Interactive’. I’m sure many of you would like to select a data point on your chart and let it act as a selection for sort of a drill-down. Doing this, although not impossible in Excel, requires sound understanding of Class Modules and chart events. I have tried to create a small example to illustrate this.

Problem Statement:I have  data for daily site views for USA, Canada and the rest of North America. While there is a top chart that shows the cumulative counts, I would like to select a data point on the chart and see a detailed view for it as below.

Chart Event Example

Chart Event Example


” As I develop …

Posted: April 9, 2014 by MaxFraudy in Others

” As I develop and serve, be patient. God is not finished with me yet.”

-Jesse Jackson

For those of you who were beginning to wonder if there was ever going to be more activity here, there is good news. Wait, just a little bit longer……….