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.
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.
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).
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.
Once you insert the arrow, your screen will look like this:
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.
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.
You can make this single headed arrow thicker. Right click the arrow and click Format Shape option.
Increase the value of Width from the Line Style window.
Click the Close button. Now your screen will look like this:
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.
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.
Change the value of Rotation from the Size section appropriately so that the arrow can be converged into the main arrow.
Close the window. Place the arrow in such a way that it just touches the main arrow. Now your screen will look like this:
Step 5. To create more single headed arrows at the bottom of the main arrow, repeat step 3.
Step 6. To add text descriptions, go to Insert-->Shapes and select Text Box (first object in Basic Shapes section).
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.
You can format the content inside the textbox going to Home option as you normally format the content.
You can format the appearance of the textbox as you want by selecting the textbox and going to Format menu option.
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.
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.)