Installation and SetupInstallation - Each User Installation - Multi-user Language Translations Personalize Your Templates
Systems2win TrainingQuick Start Initial Training New User Training Training Matrix Private Training Systems2win Leadership
Lean TrainingLean Principles Muda 8 Wastes Goal - Lean Flow Roadmap - Lean Journey Value Stream Mapping Standard Work Hansei Lean Thinking Lean Dictionary Online Lean Training Lean Leadership
CustomersOperational Excellence Lean Manufacturing Lean Office and Service Lean Healthcare Customer List
also known as Hierarchy Diagram, Decision Tree Diagram, Why-Why Diagram, How-How Diagram, Decision Tree Template, Critical To Quality Tree, Work Breakdown Structure, or Organization Chart
A tree diagram worksheet starts with a single item that branches (like a tree) into multiple items.
Use it to systematically direct your thinking to increasing levels of specific details
Choose the right type of
The generic Tree Diagram template (TreeDiagram.xlsx) can be used to create any of the following variations.
Some variations are popular or unique enough to have their own template.
Tip: If your diagram has complex arrows to illustrate complex relationships between tree elements, then sometimes it is better to use your flowchart template (FlowChart.xlsx)
Variations: Critical to Satisfaction, Critical to Process, Critical to Delivery, Critical to Cost, Critical to Schedule...
The purpose of a 'Critical To' Diagram is to ensure that the product or process characteristics that you measure and control will actually satisfy your customers' desires.
The Critical To Quality Tree Diagram is popular enough to have its own Excel template. (TreeCritical.xlsx)
And your Measurement Assessment Tree Tree Diagram (MeasuresTree.xlsx) can then be used to further refine the stratification of the specific measures for each sub-category of customers and/or delivery channels.
You might also want to use your flowchart template (FlowChart.xlsx) to perform Critical To Quality Analysis, and/or Cost of Quality Analysis.
also known as Five Whys
A Why-Why Tree Diagram is an alternative to your Fishbone Diagram template (RootCause.xlsx) to identify root causes of a problem.
Variations: Work Breakdown Structure, Job Analysis, or Task Analysis
Similar to Why-Why Diagram, but instead keep asking "How?"
Logic Diagram or Decision Tree Diagram template
A sequenced set of alternate paths that lead to a correct decision for what to do in different circumstances.
Often a flowchart is a better tool for creating a logic decision tree.
Process Decision Program Chart
To identify potential problems and countermeasures in a complex project plan.
Top cell is the project objective, next tier is main phases, third tier has the most important tasks to accomplish the phases.
Some tasks might not have significant problems.
Perhaps use a different type of shape for the Problems tier.
Perhaps use a different type of shape for the Countermeasures tier. (perhaps a cloud shape?)
Use criteria such as cost, time, effectiveness, ease...
In the text box for each countermeasure, the first character is either 'X' for impractical, or 'O' for practical.
Bill of Materials
or Gozinto chart
To illustrate the sub-assemblies, parts, and materials used to manufacture a finished good item.
To refine desired product characteristics when doing product design and development.
Also see the Characteristic Matrix that is often used when creating a PFMEA.
To illustrate the demographic breakdown of a survey population.
also known as Organizational Chart template or Hierarchy Diagram
To define organizational relationships, both formal and informal.
Most people think of an Organization Chart as being different from a Tree Diagram, but they both use the same underlying Excel Hierarchy Diagram, and the instructions for how to use both types of charts are identical.
How to use any
see the various types of Tree Diagrams (above)
Note: These instructions apply to any Systems2win template that
uses an Excel hierarchy diagram, including:
Your Decision Tree Diagram templates
come with an entire suite of Process Improvement Tools
to empower every team member to improve every process
Training for how to use your
or any template that features an Excel Hierarchy Chart
Excel 2010 and higher — convert the diagram to SmartArt graphic
Double click anywhere on the diagram, and select the radio button to Convert to SmartArt Graphic.
Tip: If you did ANYTHING to the chart before converting it to SmartArt Graphic you will need to delete it, and insert a new one. Insert > SmartArt > Hierarchy
Excel 2007 — insert a SmartArt chart
Insert > SmartArt > Hierarchy
Suggested workflow sequence
to edit any Excel organization chart template or tree diagram template
To change the size of your work space
You might need to do any or all of the following:
If you simply Hide & Unhide preformatted rows & columns then you won't need to mess with the Print Area.
In the rare event that you need to change the Print Area — see training for how to change the Print Area.
To resize the drawing space
Simply drag the corners of the drawing space
To edit text in shapes
You can simply type text in a box...
but it is usually wiser to type your text next to the bullets in the Type Your Text Here window that appears to the side of the diagram whenever you click anywhere on the diagram.
If you foolishly choose to collapse the 'Type Your Text Here' window...
you can toggle the arrow in the middle of the left border of the diagram to bring it back.
The text that you type next to the bullets will also appear in the text boxes.
Notice that in the Measures Assessment Tree Diagram template the top text boxes are not actually part of the organization chart diagram.
They are simply text boxes.
Bug: If there is not already any text in one of these top-row text boxes, then there is a bug in Excel 2010 and higher
that won't allow you to add any text so you might need to replace these text boxes with new ones.
Insert > Shapes > Textbox
To add a shape or branch
Right-click a node > Add Shape >
To move or rearrange boxes
In the Type Your Text Here window... right-click > Promote or Demote
Tip: It is a really bad idea to just drag shapes around.
Excel 2010 and higher also has the option to Move Up or Down
which actually means "Move Left" or "Move Right" if that tier is organized horizontally rather than vertically.
Tip: Before using Demote, use Move Up or Down to position the node to the right of the node that you want to Demote beneath.
Caution: It is difficult to move or rearrange the sequence of "co-worker" boxes —
so think ahead to arrange your upper level co-workers in your desired sequence.
Caution: If you are sure that you are completely done, and will never again run AutoLayout —
then you can toggle AutoLayout off, which will allow you to move and rearrange boxes.
(But if you ever toggle AutoLayout back on, then all of your moving and rearranging will be lost.)
To resize a box
Resize the entire chart, and the box sizes will adjust automatically.
Or right-click any individual shape(s) > Size and Properties
AutoLayout is a toggle. When you turn it off, you can resize boxes.
Caution: When you toggle AutoLayout back on, any new boxes that you insert will be the same size as the last box that you changed (at the same level). Systems2win recommends waiting to perform all final formatting functions as the very last thing
you do — after all shapes have been added and positioned, and the drawing space has been properly sized.
e.g. standard org chart format, left-hanging tabs, right-hanging tabs, etc.
With the diagram selected,
select the SmartArt Tools Design tab
(that appears in your Ribbon menu only when a diagram is selected)
then select your preferred type of Layout,
which should almost always be Organization Chart.
Using the Layout dropdown list
in the Create Graphic section of the Design toolbar...
each branch can have its own layout.
For example, one branch might be left-hanging, and another right-hanging.
Tip: If your tree diagram has complex arrows to illustrate complex relationships between tree elements, then sometimes it is better to use the flowchart template instead.
To format colors, fonts, and shapes
Tip: It is wise to wait until your organization chart is fully laid out before applying formatting to individual shapes
With the diagram selected, select the SmartArt Tools Design tab and/or Format tab
(that appears in your Ribbon menu only when a diagram is selected)
then have fun trying out all kinds of different styles and formats.
You can also right-click any individual shape(s) > Format Shape
To format connecting lines
Right-click any individual line(s) > Size and Properties
Tip: If your tree diagram has complex arrows to illustrate complex relationships between tree elements, then...
Text boxes, pictures, and AutoShapes
within the drawing space
Tip: Keep these elements off to the side of your drawing space until you are ready to do your final formatting.
If you identify any other tips that you feel would be helpful to include in this documentation,
please use our Feedback Form
I have a question that's not answered here
Try these other resources: