Hierarchy Chart

1 Attachment(s)

Hierarchy Chart

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"

HTML Code:

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

Attachment 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

Thanks For reading
Rajan verma

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

Password is Tree, you can view the code

Thanks