Skip to content

Home / Statistical Tools / Additional Tools / Fishbone / How-To

How-To

Build a template, draw its diagram, and see which changes show on the diagram straight away and which wait for Update Diagram. What each command does is on Fishbone, and the output and tag color cells are on Options.

Goal

Draw a fishbone diagram of the possible causes of a turned shaft coming out of tolerance, with five of the six categories filled in and each tagged cause colored by its tag.

Sample Data

The block's header row matches row 7 of the template, so it pastes straight onto the template in step 3. Do not paste it until the template exists.

Variable tag Measurement tag Method tag Machine tag Manpower tag Materials tag Environment
1 C Gauge calibration X Cutting speed N Spindle runout N Operator experience N Bar stock hardness
2 N Room temperature at the gauge X Feed rate Tool wear Shift X Bar stock supplier
3 C Coolant flow C Chuck pressure
4 Setup procedure

Steps

  1. Create the template

    Open a new, blank workbook. From the Excel ribbon, select QXL Stat Tools > Additional Tools > Problem Solving > Fishbone > Fishbone Template.

    A sheet named Fishbone Template is added after the active sheet, with cell E8 selected.

  2. Set the output and the tag colors

    Click E4, type Shaft diameter out of tolerance and press Enter.

    Click E5 and pick Automatic from its drop-down list.

    If the list offers only None and Manual, this Excel does not have the functions Automatic needs (see Options). Pick Manual instead and, after step 3, fill every C tag cell, every N tag cell and every X tag cell with a color of your choosing, one color per letter.

  3. Paste the causes and tags

    Press Copy for Excel above the table, click cell D7 on the template, and press Ctrl+V. The header row lands on row 7, over headings with the same text, and the four cause rows land in rows 8 to 11.

    With Automatic chosen, each tag cell takes its color as soon as it is pasted: every C sky blue, every N orange and every X bluish green.

  4. Draw the diagram

    With the template still active, select QXL Stat Tools > Additional Tools > Problem Solving > Fishbone > Fishbone Diagram from Template.

    A sheet named Fishbone Template Diagram is added after the template and made active.

Result

The oval reads Shaft diameter out of tolerance. Five category branches are drawn; Environment has no causes, so its title and branch are hidden.

Category Cause boxes Tag boxes
Measurement 2: Gauge calibration, Room temperature at the gauge 2: C, N
Method 4: Cutting speed, Feed rate, Coolant flow, Setup procedure 3: X, X, C. Setup procedure has no tag
Machine 3: Spindle runout, Tool wear, Chuck pressure 2: N, C. Tool wear has no tag
Manpower 2: Operator experience, Shift 1: N. Shift has no tag
Materials 2: Bar stock hardness, Bar stock supplier 2: N, X
Environment none, so the category is hidden none

That is 13 cause boxes and 10 tag boxes. Every tag is a single letter, so every tag reads upright. With Automatic, the C boxes are sky blue, the N boxes orange and the X boxes bluish green, all with black text.

See what changes straight away and what waits for Update

  1. Change a cause

    Go back to the template. You can click Gauge calibration on the diagram, which takes you to its cell, F8. Type Gauge calibration interval and press Enter.

    Go to the diagram: the box already reads Gauge calibration interval. Text changes need no update.

  2. Add a cause to the empty category

    On the template, type N in O8 and Shop humidity in P8.

    Go to the diagram: Environment is still hidden. Showing a newly filled category is a change of layout, and layout changes wait for an update.

  3. Update the diagram

    Select QXL Stat Tools > Additional Tools > Problem Solving > Fishbone > Update Diagram, from either sheet.

    The Environment branch now shows its title, the cause Shop humidity, and an N tag box, orange with Automatic: 14 cause boxes and 11 tag boxes.

See Also

  • Fishbone, the three commands and what each produces
  • Options, the output cell, the tag color choices and the Fishbone dialog