Understanding Labeled Hierarchy Charts in Excel 2007:-


To figure out two of Excel 2007’s hierarchy charts—Labeled Hierarchy and Horizontal Labeled Hierarchy—you almost need a Ph.D. However, when you figure out the bizarre layouts required in the text pane, these are really handy hierarchy charts.

The Horizontal Labeled Hierarchy offers a horizontal hierarchy chart that progresses from left to right. Each level of the chart lies in a colored band with a title. To create this chart, you follow these steps:

1. Create a single Level 1 item.

2. Beneath the first Level 1 item, build the complete hierarchy of Level 2, Level 3, and so on.

3. Count the number of levels in the hierarchy, including the first level. The chart in Figure 11.25 includes three levels. Remember this number for step 4.

4. At the bottom of the text pane, add new Level 1 entries. The first new Level 1 entry should include the title for the leftmost level of the hierarchy. The second new Level 1 entry should include the title for the second level of the hierarchy. Do not add any Level 2 text to these Level 1 entries.

When the number of bottom Level 1 entries exactly matches the number of levels in the hierarchy, the diagram snaps into place, with the titles lining up in the colored bands.

Look into the Figure (specified below).



(Getting the titles at the top of each band requires Level 1 shapes at the end of the text pane.)