Funnel charts don’t make sense. But if theres one thing we can all agree on then its that everyone else is stupid, well maybe not stupid, but not as smart as me and you, thats for sure ;-))).

So people want funnel charts, give them their cake!  Jon (Peltier) and Chandoo have some examples. Here are mine which are a little diffrent.

Method 1, is 2 stacked bar charts. The first charts picks up the data ratio, and the second shapes the funnel. I’ll not explian how to do it, you just have to nest one chart ontop of the other and set up the section width etc, dissect the chart in the example file if you want to find out more.

The good thing about this method is that it will scale well, the down side is you need a load of data points to shape the funnel (I’ve used 100, but you can use more if you like – smoother).

The next method is simpler/easyier to do, its the same stacked bar chart for the data, but this time with a XY scatter plot on top to which a couple of custom shapes have been added as markers. This has the advanatge of being relativly simple, and you can go to town on the shapes if you wanted. The down side is it does not scale well at all.

So if you’re looking for a 1/2 decent funnel chart (even though you know better) these might help. Enjoy!

Download the M.I.E Funnel Charts example.