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.
Links back to the template¶
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¶
- How-To, a template and diagram from start to finish
- Options, the output cell, the tag color choices and the Fishbone dialog
- Update Analysis, the Statistical Tools Update button
- Additional Tools