How does the Excel data make a multilevel grouped display chart? I looked at the foreign introduction when the Excel table, which has a graded display, was not aware of the severe, now learn to find is really very simple. Excel's multi-level grouping display, such as such a table, below to do step by step.
1, before you do, first set. Data → outline, dot that little sign
2, cancel the "below the details" of the hook, point to determine
3, create the first level, select all the lines below the project plan, 2→21
4, click Data-outline-combination
5, pop-up dialog box, the default selection line, determine
6, the level is done, the following to do the secondary
7, select the line below item A, 4→11
8, continue to click "Combination" to get secondary
9, Project B, dots
10, then do the third level, select the "Item a Heading 1" below the two lines, continue to click "Combination"
11, get the third level combination
12, Dots, make other three-level combination. The whole effect is as shown.