Buy Now

Fishbone Diagram 

Excel and Google Sheets Template

Identify and diagram causes and effects to a problem with our color-coded, customizable and dynamic Fishbone Diagram Excel and Google Sheets Template.  
Buy Now
Video Poster Image

What's Inside the Fishbone Diagram Template?

Details | 2 Sheets 

Supported Versions | Excel 2010, 2013, 2016, 2019, Office 365 (Mac), Google Sheets

Category | Supply Chain & Operations, Data Analysis

Tags | Cause and Effect, Ishikawa, 7 Basic Tools of Quality Control

Why Professionals Choose Simple Sheets

It's simple. Access to the largest library of premium Excel Templates, plus world-class training.

100+ Professional Excel Templates

100+ Professional Excel Templates

Optimized for use with Excel. Solve Excel problems in minutes, not hours.

Buy Now
World-Class Excel University

World-Class Excel University

With our university, you'll learn how we make templates & how to make your own.

Explore Catalog
How-To Videos

How-To Videos

Each template comes with a guide to use it along with how-to videos that show how it works.

Buy Now

Inside Our Fishbone Diagram

Excel and Google Sheets Template

Input your causes into the Brainstorming section. The headlines are the 5 M's. in this Excel and Gsheets Template

The Fishbone Diagram is the Shaquille O’Neal of quality control tools.

Not for any other reason than it has about five different names it goes by - Ishikawa, Herringbone, Cause-and-Effect and even Fishikawa. Shaq, the famous basketball player, claimed himself The Big Aristotle, Superman and Diesel to name a few.

Sports aside, the Fishbone Diagram is a process for identifying root causes that contribute to a particular effect. Essentially, it seeks to find a cause and effect relationship to prevent further quality defects.

If you find this template helpful, you’ll also want to check out the other seven basic tools of quality templates in our library such as Check Sheet, Stratification, Pareto Chart and Scatter Diagram. Each of these templates is designed around helping you better identify relationships, reduce defects and improve efficiencies.

Before diving into this template, the first step is evaluating the 5 Ms: Man, Machine, Materials, Method and Measurement. Assign each issue to one of these categories. Record all issues in the left side of the table according to the category.

In the Impacting column, select the dropdown list and the degree of the problem for each reference according to A, B and C.

The Fishbone Diagram will auto populate according to your inputs with conditional formatting that highlights the most intense contributing factors.

If you’re sharing this with a manager or colleague, click Full Screen to maximize the visual. Want to start over from scratch? No problem, just make sure to save if you want to reference that copy and click Clear Data. Both buttons are in the top right corner of the Fishbone Diagram sheet.

One of the best features of this template is the ability to customize it to other use cases. It can also be used for the 8 Ps, known as the marketing mix. Just change the headers to Product, Price, Place, Promotion, People, Process, Physical Evidence and Performance. 

If that wasn't enough reason to get this template, did you know this template is compatible with Google Sheets? Collaborate with your co-workers in real time and enjoy the cloud auto-save feature of Sheets when you use this template!

To tailor it to the service industry, you can change the headers to the 4Ss; Surroundings, Suppliers, Systems and Skills.

Our Fishbone Diagram Excel Template helps you evaluate the cause and effect of supply chain and operations issues

More Operations Templates For You

Simple Pricing for Full Access

Unlock full access to the entire library for one low price.

Limited

$49

(no bundle savings)

  • 45+ Customizable Excel Templates
  • One User
  • One-Time Payment
BUY NOW

Premium + University

$199

($699 bundle savings)

  • Full Access to Excel University ($399 bundle savings)
  • 100+ Customizable Excel Template
  • Personal Membership Portal
  • Excel, PowerPoint, & Word 101 Courses ($199 bundle savings)
  • Two Users
  • One-Time Payment
BUY NOW

Premium

$99

($299 bundle savings)

  • 100+ Customizable Excel Templates
  • Excel, PowerPoint & Word 101 Courses ($199 bundle savings)
  • One User
  • One-Time Payment
BUY NOW