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

HirarchyChart.jpg

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



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