In work areas, it is very common to use resources that help us organize information, among them we have the tree diagram. The important thing is to use tools that help us; In this section we will teach you how to create and analyze an Ishikawa diagram in Word, Excel, Power Point and in Minitab . By using it you will realize how advantageous it is for problem solving.

Ishikawa’s diagram

It is an excellent tool that allows us to visualize the problem from another angle or central focus. The diagram is made up of a fish head , which represents the Problem, from there the central spine emerges. Deriving major causes or main thorns. In turn, larger spines are caused by smaller spines or small problems.

diagrama de ishikawa con forma de pescado

Creation and analysis of the Ishikawa Diagram

  • We must take into account brief points such as the definition of the Problem.
  • Then we write down the brainstorming that causes the problem. Originating the Greater Thorns.
  • Then, we analyze the possible minor causes that result in the major causes.
  • And continue the analysis until all the areas that affect said problem are completed.

There are several types of diagram according to your needs, we have the method of 6m, 8ps (oriented to marketing), 4s (oriented to the service industry). You can then create the Ishikawa diagram in Word, Excel, Power Point, and Minitab in easy steps.

In excel

On the internet they have Templates that allow you to make the diagram in a simple way. You just have to download them and fill in the spaces. On the web we find the page They have several types of diagrams, depending on what you need:

  1. Click on the title of the diagram
  2. A dialog window will appear, where you will indicate the place to download and click Save.
  3. Once downloaded, you open the template, which will open the Excel program.
  4. In order to work and edit it, you will have to press the “Enable Editing” button. And ready.! You just have to fill in each space.

Power point

The procedure is very similar. We found a website called plandemejora (.com). They have several models of templates. To download it, on the web they tell you where to click.

  1. Once downloaded, open the template, and you will see the diagram in Power Point.
  2. To edit it, press the “Enable Editing” button . And ready.!

In Word

If you have basic knowledge of Word, you can do it manually. In which you will use only lines, arrows and figures for the cause and effect scheme. Start by opening the Word program and perform these steps ..:

  1. In the top menu go to the “Insert” tab.
  2. In the Illustrations area, tap the “Shapes” icon. Insert straight arrows and draw them in the center of your workspace.
  3. Finishing the arrow, choose another figure in the shape of a Rectangle. In it you will write the problem.
  4. Now keep adding more main arrows that discharge onto the center arrow at an angle of roughly 70 or 60 degrees.
  5. Each main arrow you will place another rectangle indicating the causes of the central problem.
  6. In turn, draw alternate lines to the “Cause” with labels that will write down possible problems that this “Cause” causes.
  7. Once the arrows and rectangles are labeled, the Ishikawa Diagram should resemble a fish skeleton. And ready.

If what you want is the shortcut, you can choose the same website that we recommend for Excel models, namely, diagramdeishikawa (.com). They also provide templates in Word. Its procedure to download them is the same as we explained in Excel.

With Minitab

  1. Open a new file in Minitab
  2. In the statistics tab, click “Quality Tools” and then “Cause and Effect.”
  3. In “Causes” in branch 1, you must select “Column”.
  4. With the field blank, select “Cause” for branch 1 and enter the Problem.
  5. To add more branches, repeat steps 3 and 4. These would be the Causes.
  6. In “Effect” the ideas that affect the “Cause” are noted.
  7. To finish, click on “Accept”.

diagrama de pescado en minitab

We hope that the development of the Ishikawa Diagram will be very useful to detect the causes of a problem . We indicate the different options that you have at your disposal. We also have a section to make timeline diagrams easily. If you want to share your impression, leave your comments.

Helpful?, please rate!
[Total: 0 Average: 0]