A Fishbone diagram (or Ishikawa diagram) is a tool often used in lean an quality management for helping articulate route causes analysis.

It’s commonly used to help in defect analysis when you need to brainstorm possible causes of an issue. (click the link to find out more about fishbone diagram).

The diagram is structured around an issue – that runs through the center line – route causes are shown as spikes running from the centre and sub clauses are associated with the route cause lines.

Creating a fishbone diagram is fairly easy – you can create one using Microsoft Excel in no time at all.

Check the video below for the how to

1/ Create a new workbook – turn off gridlines and add in the drawing toolbar
2/ Use the line tool and arrow tool to create the basic framework
3/ Use the text box tool to create titles for the route causes
4/ Use a combination of text boxes and lines to create sub-clauses

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google

Related posts:

  1. Creating a fishbone diagram or cause and effect diagram in Visio
  2. Introduction To the Fishbone Diagram
  3. Creating a SIPOC diagram template in Excel
  4. Example Radar Chart – how to create a Radar Chart in Microsoft Excel
  5. Using Excel to draw Spaghetti Diagrams

Comments

3 Responses to “How to create a Fishbone Diagram template using Microsoft Excel”

  1. Madhumita banik Batra on July 13th, 2010 6:04 pm

    I wanted to create Fish bone diagram for Product defect … How to create pls help me

  2. Pikesway on August 31st, 2010 3:40 am

    Here is another version of an fishbone template in excel. Simply fill out the table and the diagram populates itself. There are some limitations to this template but I’ve found it useful.
    http://scorecardanalysis.blogspot.com/2010/08/fishbone-ishikawa-diagram-template.html

  3. Hitesh Patel on September 1st, 2010 11:59 am

    I want to redesign the blower package base on VOC,Help for the same. How to proceed? Which will be the born?

Leave a Reply