How to Make Fishbone Diagram in Excel (with Easy Steps)

Sometimes you may need to visualize a business case. In that case, you may need to make a Fishbone diagram in Excel in which you can describe the problems and effects. Furthermore, you can easily find out the solution by analyzing the Fishbone diagram. Thus, I will explain how to make a Fishbone diagram in Excel in this article.


Download Practice Workbook

You can download the practice workbook from here:


What Is a Fishbone Diagram?

The Fishbone diagram is basically a way to visualize the main causes and effects of any problem. This is also known as the Ishikawa diagram. This diagram is very helpful for the company manager or owner to understand the problems, search the solution and predict the result.


8 Steps to Make Fishbone Diagram in Excel

You can use the Shape feature to make the Fishbone diagram in Excel. Moreover, you can do a lot of things using this Shape feature in Excel. Actually, the Shape feature has different types of Shape.

Now, let’s start making a Fishbone diagram. In addition, I’m going to use the following dataset for your better understanding. Basically, the dataset describes the problems of the Supply Chain system in a manufacturing company.

How to Make Fishbone Diagram in Excel


Step 1 : Inserting Fish Head

In this section, I will insert the Fish Head of the Ishikawa diagram. The steps are given below.

  • Firstly, from the Insert tab >> you need to go to the Shapes feature.
  • Secondly, you have to select the Delay shape which is in the Flowchart section.

  • Now, you have to drag the Mouse Pointer. Here, you need to drag the Mouse Pointer where you want to keep the Fish Head

How to Make Fishbone Diagram in Excel

  • After that, double click on the shape and you will see the Text Bar to write.

  • At this time, you have to write the focus worlds of the diagram. Here, I have written “Manufacturing Supply Chain”.

How to Make Fishbone Diagram in Excel

  • Furthermore, you can simply change the Shapes location dragging the Mouse Pointer.

Read More: How to Show Menu Bar in Excel (2 Common Cases)


Step 2 : Formatting Text in Fish Head

In this section, I will do the formatting of the text which I have written before inside the Fish Head. Moreover, the formatting will be totally according to your preference.

  • Firstly, you should select the Text.
  • Secondly, from the Home tab >> you may go to the Alignment feature. Here, I have done Center and Middle alignment.

How to Make Fishbone Diagram in Excel

  • Now, you should check whether the Text is selected or not.
  • Then, from the Home tab >> you may change the Font Size. Here, I have increased the Font Size to 16.


Step 3 : Including Main Bone of Fish

Now, I will include the Main Bone of Fish for the Ishikawa diagram.

  • Firstly, from the Insert tab >> you need to go to the Shapes feature.
  • Secondly, from the Lines command >> you have to select the Line shape.

  • Now, you have to drag the Mouse Pointer. Here, you need to drag the Mouse Pointer towards the Fish Head
  • Then, from the Shape Format tab >> go to the Shape Outline.
  • After that, from the Weight option >> choose your preferred line weight. Here, try to choose a weight that will keep the diagram visible.

How to Make Fishbone Diagram in Excel

Finally, you will get the following output.


Step 4 : Adding Fish Bones

Now, I will add the Fish Bones to make the Fishbone diagram in Excel.

  • Firstly, from the Insert tab >> you need to go to the Shapes feature.
  • Secondly, from the Lines command >> you have to select the Line shape.

How to Make Fishbone Diagram in Excel

  • Now, you have to drag the Mouse Pointer. Here, you need to drag the Mouse Pointer towards the Fish Head and Main Bone

  • Now, you need to select the shape.
  • Then, from the Shape Format tab >> go to the Shape Outline.
  • After that, from the Weight option >> choose your preferred line weight. Here, try to choose a weight that will keep the diagram visible. Also, try to keep this thin than the Main Bone.

How to Make Fishbone Diagram in Excel

Here, you can move the whole diagram by selecting all those shapes by using the Ctrl key.

  • At this time, to draw more bones, you can copy the bone using Excel keyboard shortcuts Ctrl+C and then paste the bone pressing Ctrl+V keys. This is the easiest way to add lots of bones. When you have so many causes to describe you must use this shortcut.

How to Make Fishbone Diagram in Excel

Finally, you will see the following shapes.


Similar Readings


Step 5 : Inserting Fish Tail to Make Fishbone Diagram in Excel

At this time, I will insert the Fish Tail to complete the Fish shape.

  • Firstly, from the Insert tab >> you need to go to the Shapes feature.
  • Secondly, you have to select the Isosceles Triangle shape which is in the Basic Shapes section.

How to Make Fishbone Diagram in Excel

  • Now, you have to drag the Mouse Pointer. Here, you need to drag the Mouse Pointer where you want to keep the Fish Tail
  • Then, you should rotate the shape to look like a Fish Tail.

Lastly, you will get the Fishbone Shape.

How to Make Fishbone Diagram in Excel


Step 6 : Including Chevron Arrow to Narrate Data for Making Fishbone Diagram

In this section, I will include the Chevron arrow to narrate the fact in the Ishikawa diagram.

  • Firstly, from the Insert tab >> you need to go to the Shapes feature.
  • Secondly, from the Block Arrows option >> you have to select the Chevron arrow shape.

  • Now, you have to drag the Mouse Pointer. Here, you need to drag the Mouse Pointer where you want to keep the shape.
  • Then, Right-Click on the shape.
  • Subsequently, from the Context Menu Bar >> go to Fill option >> then you may change the fill color. Here, I have chosen Orange, Accent 2, Lighter 60%. In this case, try to choose any light color. Because, the dark color may hide the inputted data. Then, you may need to change the Font Color again.

How to Make Fishbone Diagram in Excel

  • At this time, to draw more Chevron arrows, I used Excel keyboard shortcuts Ctrl+C keys to copy them and Ctrl+V keys to paste them. This is the easiest way to add lots of arrows. When you have so many causes to describe you must use this shortcut.

Last but not the least, you will see the following shape.

Read More: How to Move Up and Down in Excel (5 Easy Methods)


Step 7 : Placing Line Arrow to Make Fishbone Diagram in Excel

Now, I have to place Line Arrows to make the Fishbone diagram more understandable.

  • Firstly, from the Insert tab >> you need to go to the Shapes feature.
  • Secondly, from the Lines command >> you have to select the Line Arrow shape.

How to Make Fishbone Diagram in Excel

  • Now, you have to drag the Mouse Pointer. Here, you need to drag the Mouse Pointer towards the Fish Bones

  • At this time, to draw more Line Arrows, I used Excel keyboard shortcuts Ctrl+C keys to copy them and Ctrl+V keys to paste them. This is the easiest way to add lots of arrows. When you have so many causes to describe you must use this shortcut.

Last but not the least, you will see the following shape.

How to Make Fishbone Diagram in Excel

Read More: [Fixed!] Up and Down Arrows Not Working in Excel (8 Solutions)


Step 8 : Inserting Data in Fishbone Diagram

At last, I have to insert the data as text to make the Fishbone diagram readable.

  • Firstly, you need to write the causes inside of the Chevron arrows.

At this time, to describe the causes you should use the Text Box feature.

  • Firstly, from the Insert tab >> you should go to the Text command.
  • Secondly, click on the Text Box feature.

How to Make Fishbone Diagram in Excel

  • Now, you have to drag the Mouse Pointer. Here, you need to drag the Mouse Pointer above the Line Arrow

  • Now, write the description in the box.
  • Then, select the box.
  • After that, from the Home tab >> change the Alignment to Middle and Center.
  • Subsequently, from the Fill option >> choose No Fill.

How to Make Fishbone Diagram in Excel

  • Similarly, write the description for the other arrows.

Lastly, you will see the Fishbone diagram.

Here, I have attached a clear view of the Ishikawa diagram.

How to Make Fishbone Diagram in Excel

Read More: How to Move Data from Row to Column in Excel (4 Easy Ways)


💬 Things to Remember

  • If you change the length or width of any column or row then the diagram will also be either elongated or narrated.
  • Moreover, this is totally a manual process. Thus, you have to change every shape individually.

Conclusion

I hope you found this article helpful. Here, I have explained 8 easy steps to make a Fishbone Diagram in Excel. You can visit our website Exceldemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Musiha

Musiha

I am Musiha, graduated from Naval Architecture and Marine Engineering Dept., BUET, currently residing in Dhaka, Bangladesh. And my passion is to grow up my skillsets with industry demands.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo