Each level of the tree should follow the order of IDs described in Excel.
I cannot find an easy way to control the order of aparience of items in the generated chart.

Also the rol column control de color of boxes. If I changed the list with my own names (a logic visual step) all appears in the same yellow color in the chart.