Results 1 to 3 of 3

Thread: Hierarchy Chart

  1. #1
    Member Rajan_Verma's Avatar
    Join Date
    Sep 2011
    Posts
    81
    Rep Power
    14

    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
    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

  2. #2
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14
    It runs fine using xl2007 --- hmmm -- But your code is Password protected
    xl2007 - Windows 7
    xl hates the 255 number

  3. #3
    Member Rajan_Verma's Avatar
    Join Date
    Sep 2011
    Posts
    81
    Rep Power
    14
    Password is Tree, you can view the code

    Thanks

Similar Threads

  1. Hierarchy Chart :
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 0
    Last Post: 06-06-2013, 07:53 PM
  2. Replies: 1
    Last Post: 11-30-2012, 09:23 AM
  3. Excel Chart Showing Values on Angle: Nightingale Chart
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 0
    Last Post: 10-17-2012, 06:39 PM
  4. Replies: 1
    Last Post: 05-20-2012, 12:23 PM
  5. 2007 PPT Chart Data is not Reflecting In Chart
    By littleiitin in forum Powerpoint Help
    Replies: 2
    Last Post: 04-28-2012, 01:42 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •