Traditional Culture Encyclopedia - Traditional stories - Excel how to generate the parent-child relationship to the tree structure of the hierarchical chart_excel tree structure data

Excel how to generate the parent-child relationship to the tree structure of the hierarchical chart_excel tree structure data

1, open the Excel table, select the data.

2, selected data, click the toolbar in the data.

3, into the data page, click the hierarchical display of the lower right corner of the icon.

4. After clicking the icon, the setting window pops up, and you can choose whether the grading display is on the top or on the left.

5. After choosing the top, the menu of grading display will be on the top, clicking "-" will hide it, and clicking "" will show it.