Ishikawa Diagram

Ishikawa diagrams, popularly known as fishbone diagrams or cause and effect diagrams, are mainly used in quality management in order to analyze inefficiencies in workflow processes. Using fishbone diagrams, all the components that are part of the workflow can be analyzed and hence the problems causing some kind of inefficiencies can be easily and efficiently identified. In other words, ishikawa diagrams can help you identify defects in your processes by analyzing causes of an issue.

Ishikawa Scheme

The main center line of the ishikawa diagram represents an issue or a problem. The root causes are shown as spikes running from the center and the secondary causes are associated with the route cause lines. You can create ishikawa diagrams easily using Excel. You just have to insert the required shapes, whether arrows, rectangles or circles, and add the description. You can find all the required shapes and textbox (to insert the description) in the Insert --> Shapes menu option.

Shapes Ribbon

Create Ishikawa Diagram

Step 1. Open Excel 2010 and save your file as ishikawa-diagram.xlsx. Go to Insert (main menu) --> Shapes (in the Illustrations group) and select the first arrow in the Block Arrows section (circled in red).

Block Arrows

Just drop in the arrow anywhere on your Excel worksheet. You can change the size, position or color of any shape using the Format menu option and you will see the Format menu option only if you select the shape to be formatted.

Drawing Tools Format

Once you insert the arrow, your screen will look like this:

Format Arrow

The size, position and color of your arrow could be different. Make sure that your arrow is lengthy enough with enough space at the top and bottom so that you can insert other spikes.

Step 2. Go to Insert (main menu) --> Shapes (in the Illustrations group) and select the second arrow (single headed arrow) in the Lines section.

Lines Selection

Drop in the arrow anywhere on your Excel worksheet. Then, drag it in such a way that its arrow touches the main arrow we positioned in Step 1.

2 arrows

You can make this single headed arrow thicker. Right click the arrow and click Format Shape option.

Format Shape

Increase the value of Width from the Line Style window.

Shape Width

Click the Close button. Now your screen will look like this:

2 arrows formatted

Step 3. To create more single headed arrows at the top of the main arrow, right click the arrow created in step 2 and copy (CTRL + C) and paste (CTRL + V) it as many times as the number of arrows you need at the top. Place them in the correct positions so that all of them converge into the main arrow. You can adjust the length of the main arrow if you want.

4 arrows

Step 4. Next to create arrows for the bottom of the main arrow, copy one single headed arrow at the top and paste it somewhere on the worksheet. Right click the copied single headed arrow and select Size and Position option.

Size and Position

Change the value of Rotation from the Size section appropriately so that the arrow can be converged into the main arrow.

Shape Rotation

Close the window. Place the arrow in such a way that it just touches the main arrow. Now your screen will look like this:

5 arrows

Step 5. To create more single headed arrows at the bottom of the main arrow, repeat step 3.

7 arrows

Step 6. To add text descriptions, go to Insert-->Shapes and select Text Box (first object in Basic Shapes section).

Basic Shapes

Drop it in the worksheet where you want to insert description. Add the description by just clicking inside the textbox and typing whatever you want.

Insert Description

You can format the content inside the textbox going to Home option as you normally format the content.

16 people

You can format the appearance of the textbox as you want by selecting the textbox and going to Format menu option.

Format TextBox

Step 7. Copy and paste as many text boxes as you want and place them in correct positions with proper descriptions. Also add a textbox at the end of the main arrow and provide a description that explains the actual problem that is being analyzed.

Text End Arrow

Step 8. Repeat from step 2 in order to add more spikes which point to each of the single headed arrows. Format and position them appropriately with proper text descriptions. Your final ishikawa diagram will have a structure like this: (Of course, there will be differences in the size, color, position, text descriptions, number of spikes etc. Still, the basic structure will be the same.)