To help structure the approach, the categories are often selected from one of the common models shown below, but may emerge as something unique to the application in a specific case.
A Fishbone Diagram is another name for the Ishikawa Diagram or Cause and Effect Diagram.
You can reference the information on this page using an inline text link, or something similar to the following citation: - Wittwer, J.
W., "Fishbone Diagram / Cause and Effect Diagram in Excel," From Vertex42
The following downloads may help you get started, and if you continue reading, I've included some detailed information about how to use the diagrams.
Create a cause and effect diagram with a spreadsheet.Although not angled like most fishbone diagrams, this template is very simple to edit and customize (as opposed to constantly moving and aligning text boxes and arrows).The purpose of a cause and effect analysis is to identify the causes, factors, or sources of variation that lead to a specific event, result, or defect in a product or process.For example, a light bulb that burns out pre-maturely (the effect) might be caused by a sudden jarring motion such as dropping, which might be listed under the category People if it was associated with handling by a person (as opposed to machine handling).A Secondary Cause is a cause that could lead to a Primary Cause, but does not directly cause the end effect.This diagram is used in process improvement methods to identify all of the contributing root causes likely to be causing a problem.The Fishbone chart is an initial step in the screening process.Cause and Effect Analysis gives you a useful way of doing this.This diagram-based technique, which combines Brainstorming Cause and Effect Analysis was devised by professor Kaoru Ishikawa, a pioneer of quality management, in the 1960s.It gets its name from the fact that the shape looks a bit like a fish skeleton.A fish bone diagram is a common tool used for a cause and effect analysis, where you try to identify possible causes for a certain problem or event.