The consulting job reminded me of a few charts I used to create a lot when I was still at firm. The interesting ones besides those common are waterfall chart and mosaic plot. These are the survival charts that a management consultant needs to master. Unfortunately Excel can’t produce these without some add-on and macro plug-in, so you may spend lots of time fighting with these in consulting project.
Waterfall: A useful charting when you want to show the breakdown, e.g. revenue/cost structure.
Mosaic Plot: Very handy chart when you want to show share/scope in 2D, e.g. market share, head count structure.