Skip to content

Home / Statistical Tools / Additional Tools / Fishbone

Fishbone

From Excel click...

QXL Stat Tools > Additional Tools > Problem Solving > Fishbone

A fishbone diagram, also called a cause-and-effect or Ishikawa diagram, lists the possible causes of one output, grouped into categories. In Quantum XL you type the causes into a Fishbone Template sheet, and Quantum XL draws a Fishbone Diagram sheet from it.

The Fishbone menu has three commands:

Command What it does
Fishbone Template Adds a new template sheet to the active workbook
Fishbone Diagram from Template Draws a diagram sheet from the active template sheet
Update Diagram Brings the diagram up to date with its template, from either sheet

The Update button in the Statistical Tools group of the same tab does the same thing as Update Diagram when a Fishbone template or diagram sheet is active.

Nothing is calculated. None of the three commands has a settings dialog; the two input cells on the template are described on Options. For a worked example, see How-To.

Fishbone Template

Adds a sheet named Fishbone Template to the active workbook, directly after the active sheet, and selects cell E8, the first tag cell. The sheet has room for 6 categories of 12 causes each. If the workbook already has a sheet of that name, Excel names the new one Fishbone Template (2), and so on.

Cells What goes there
C2 a link, Help for Fishbone templates and diagrams, that opens this page on the help website
E4 the output, the effect the diagram is about. It starts as Output and is labeled Output: in D4
E5 how tags are colored: None, Automatic or Manual. It starts as None and is labeled Tag colors: in D5. See Options
F7, H7, J7, L7, N7, P7 the six category titles. They start as Measurement, Method, Machine, Manpower, Materials and Environment, and you can type over any of them
F8:F19, H8:H19 and so on up to 12 causes under each category title
E8:E19, G8:G19 and so on an optional tag for the cause in the cell to its right
D8:D19 the numbers 1 to 12, one per cause row
D21 a reminder of the next step: Enter causes and tags, then click QXL Stat Tools tab > Additional Tools > Problem Solving > Fishbone > Fishbone Diagram from Template.

Each category takes two columns: the tag on the left and the cause on the right. The row 7 headings above the tag columns read tag.

The template is set to print landscape on one page, centered.

You can make as many templates as you like, in the same workbook or in others. Each template keeps track of its own diagrams.

Fishbone Diagram from Template

Click a cell on a template sheet first. The command reads the active sheet, so it must be a Fishbone template.

The first time, it adds a diagram sheet directly after the template and names it after the template: a template called Fishbone Template gets a diagram called Fishbone Template Diagram. A name longer than Excel's 31-character limit is cut short, and if the name is already taken, (2), (3) and so on is added. The diagram is set to print landscape on one page, centered. Cell B2, under the diagram's title, holds the same help link as the template.

When the template already has a diagram, a dialog titled Fishbone asks: This template already has a diagram. Would you like to update the existing diagram or create a new diagram? Its buttons are described on Options.

What the diagram shows

The diagram has a fixed layout of 6 category branches, three along the top and three along the bottom, each with room for 12 causes, and an oval holding the output. Only the parts that have something in them are shown:

Part Shown when
a cause box and its arrow the cause cell has text
a tag box beside a cause both the cause cell and its tag cell have text
a category title and its branch at least one cause in that category has text
the output oval always

So a category title with no causes under it does not appear, and a tag with no cause beside it does not appear either. Leading and trailing spaces are ignored, so a cell holding only spaces counts as empty.

Tag boxes stand on end beside their cause. A one-character tag reads upright; a longer tag is written along the box, reading from bottom to top.

The output text is sized to fit the oval, starting at 24 points and shrinking one point at a time to a smallest size of 10 points. Text that does not fit even at 10 points is cut off.

Text changes when you leave the cell; Update does the rest

Every piece of text on the diagram is linked to its cell on the template. Change a cause, a tag, a category title or the output on the template, and the diagram shows the new text as soon as you leave the cell. There is nothing to press.

Everything else waits for Update:

  • showing a cause, tag or category you have just filled in, and hiding one you have just cleared
  • the direction a tag is written
  • tag colors
  • the size of the output text

So after adding or clearing causes, run Update Diagram.

Update Diagram

Run it from either sheet:

Active sheet What happens
a diagram that diagram is brought up to date with its template
a template that has diagrams every diagram made from that template is brought up to date
a template with no diagram it asks This template has no diagram yet. Create one? Yes draws one
any other sheet Update Diagram shows a message asking for a Fishbone sheet. The Statistical Tools Update button carries on with its usual job instead; see Update Analysis

If any of the diagrams to be updated is a protected sheet, nothing is updated and a message names the sheet.

If shapes have been deleted from a diagram, the rest of the diagram is still updated, and a message lists the shapes that were missing.

Click any cause, tag, category title or the output on the diagram to go to its cell on the template. Hovering over one shows a tip: Go to this cause in the template, Go to this tag in the template, Go to this category in the template or Go to the output in the template.

The links keep working after you rename the template sheet.

Copying sheets

Copy a template and its diagram together, in one copy, and the copied diagram belongs to the copied template: its text points at the copied template, and Update Diagram treats it that way.

Sheets from the previous version

Sheet made by the previous version What happens
a template it works as a template, with two differences: it has no output cell, so the oval keeps the word Output and has no link back to the template; and it has no tag color cell, so tag colors are always None
a diagram it cannot be updated, because it does not record which template it came from. Open its template and run Fishbone Diagram from Template to make a new, linked diagram

Messages

Every message below is in a box titled Fishbone.

Message When
A cell is still being edited. Finish editing the cell, then try again. any command run while you are still typing in a cell. Press Enter or Esc first
Open a workbook before creating a Fishbone template. Fishbone Template with no workbook open
Open a workbook before creating a Fishbone diagram. Fishbone Diagram from Template with no workbook open
Open a workbook first. Update Diagram with no workbook open
This workbook's structure is protected. Unprotect it (Review > Protect Workbook) and try again. a command that needs to add a sheet, in a workbook whose structure is protected
Select a Fishbone Template sheet first, then click Fishbone Diagram from Template. Fishbone Diagram from Template on a sheet that is not a template
Select a Fishbone Template or Fishbone Diagram sheet first. Update Diagram on a sheet that is neither
This diagram was made by an older version of Quantum XL and is not linked to a template. Open its template and click Fishbone Diagram from Template to make a linked diagram. Update Diagram on a diagram from the previous version
The template this diagram was made from is no longer in this workbook. Update Diagram on a diagram whose template was deleted
The sheet '...' is protected. Unprotect it (Review > Unprotect Sheet) and try again. an update that includes a protected diagram sheet
These diagram shapes are missing on the sheet '...', so parts of the diagram were not updated: followed by the shape names a diagram that has had shapes deleted
The Fishbone template file was not found: followed by a file path any command that adds a template or a diagram sheet, when the file the sheets are copied from, qxlFishbone.xlsx in the Templates folder of the installed product, is missing

Each command also refuses to start while Quantum XL is busy, in a box titled with the command's name (Fishbone Template, Fishbone Diagram or Update Diagram). From the Statistical Tools Update button, the same messages are titled Update Sheet:

Message When
A Quantum XL analysis is still running. Wait for it to finish, then try again. an analysis is still being built
The Data Selection window is already open. Finish or cancel it, then try again. the Data Selection window is open
A Quantum XL Monte Carlo window is already open. Finish or cancel it, then try again. a Monte Carlo window is open

When the workbook structure is protected and the template already has diagrams, Fishbone Diagram from Template does not ask and does not show a message: it updates the existing diagrams, because a new sheet could not be added.

See Also