Recently one of my friends asked me to help him in creating a cascaded chart in Excel which looked something like the following:
There are several sites which offer an add in to create this for $$ and there are many blogs which show how to create it manually. Creating it manually took some time and was a little cumbersome. Being an ex consultant who worked in creating presentations, I thought why not automate it using a macro (writing code/recording) . Any people will have to use it for multiple presentations multiple times. I thought I could take it to next step and automate the entire thing from creating the data required for the graph from the generic data using some config variables. The final result is something sort of a fully automated template which can generate this graph with the click of a button.
I tested it for multiple scenarios and works as expected. There would be some scenarios I missed and would be happy if someone communicates it to me. It will be also great if you have further enhancements and I can work to take it to the next level.
The template file can be downloaded from the following location:
This is one of the best helps i have ever got on cascaded charts.
ReplyDeleteCreate another blog where you provide a step by step approach to modify it suitably so that i can make cascade chart for more than for columns and how to color it such that the bottom is white (will help me in showing a cumulative frequency distribution chart)
Thank you. This tool is actually customized for multiple columns. You can actually increase the columns by specifying the number of suppliers in the top rows and adding columns appropriately to the data set. The macro will take care of the rest.
DeleteAs you mentioned, I will work on a similar template to show cumulative frequencies soon.