Hierarchy Chart

[Rajan_Verma]

Hi People,
I am happy to share a chart created using VBA to show data hierarchy, find the attached sheet to use the chart, you just need to double click on series to show next level data

I am using data like below table : you can find total 5 level in this data like Globe , Region, Country, State and Level5 and two data column "Value" and "Share"


Globe Region Country State Level5 Value Share
Globe1 Region1 Country1 State1 Level2 89813 92317
Globe1 Region1 Country1 State1 Level2 52935 58673
Globe1 Region1 Country1 State1 Level2 92593 78854
Globe1 Region1 Country1 State1 Level3 66510 51612
Globe1 Region1 Country1 State1 Level3 28419 48051
Globe1 Region1 Country1 State2 Level1 75384 56253
Globe1 Region1 Country1 State2 Level2 90935 33760
Globe1 Region1 Country1 State2 Level3 60747 18744



460

Dynamic things:

This chart can show the of any selected column in "Chart" workSheet ,you can enter any Data Column name in this Cells,
If you want to increase the Number of Level to be show in the chart, just update the level number in the Max Level Cell
If you want to change the format of Data Lables in chart , you can apply any format here in the cell, that will be applied for chart lables


Value Column Name Share Format 1
Max Level 5


Note : I have tried it on Excel 2007 , but crashing excel (would be great if anyone can find the issue) , so you can use Excel 2010 .



You can download the file from here :
Hierarchy Chart : « excelpoweruser (http://excelpoweruser.wordpress.com/2012/11/23/hierarchy-chart/)



Thanks For reading
Rajan verma

[Rasm]

It runs fine using xl2007 --- hmmm -- But your code is Password protected

[Rajan_Verma]

Password is Tree, you can view the code

Thanks