I was asked if I could provide a solution to a consultant who required a Sales Funnel type of chart but which was more flexible than the old Add-on provided my Matt Lloyd, and one in which the colours can be bound to cells rather than static.  Was there an 'out of the box' solution?

Here's my effort:

A bit rough and ready but with a few hours spent refining the solution I think it would work well.

Download the xlf file here: