Skip to content

Home / Statistical Tools / Additional Tools / Fishbone / Options

Options

None of the three Fishbone commands has a settings dialog. What the diagram shows is set by two cells on the template, E4 and E5, and by the causes, tags and category titles you type. The one dialog, which asks whether to update a diagram or create another, is described at the end. What each command does is on Fishbone.

Output (cell E4)

Labeled Output: in D4. It starts as Output.

The text in E4 is shown in the oval at the head of the diagram. The text is linked to the cell, so a change shows on the diagram as soon as you leave the cell. Its size is set when the diagram is drawn or updated: 24 points, or smaller, down to 10 points, if that is what it takes to fit inside the oval.

Tag colors (cell E5)

Labeled Tag colors: in D5. It starts as None. Click the cell to pick from its drop-down list:

Choice Tag cells on the template Tag boxes on the diagram
None left as they are all the same standard color: the workbook theme's Accent 3 color, lightened, with dark text
Automatic colored by Quantum XL as soon as you leave the cell, as described below copy the color of their tag cell
Manual you fill each tag cell with any color you choose copy the color of their tag cell

The diagram picks up tag colors when it is drawn or updated, not as you type. After changing the choice in E5 or recoloring a tag cell, run Update Diagram.

In Automatic and Manual, the tag text on the diagram is black or white, whichever stands out more against the box color.

Automatic

Quantum XL colors every tag cell on the template from a set of eight colors. Tags with the same text get the same color, and capital and small letters count as the same. Excel's matching treats *, ? and ~ in a tag as wildcards, so a tag containing one of them can take the color of another tag it matches.

Order Color Hex Text
1 sky blue 56B4E9 black
2 orange E69F00 black
3 bluish green 009E73 black
4 reddish purple CC79A7 black
5 blue 0072B2 white
6 vermilion D55E00 black
7 yellow F0E442 black
8 gray 999999 black

The tags C, N and X always get colors 1, 2 and 3. In cause-and-effect work these letters are commonly used to tag a cause as Controllable, Noise or eXperimental. Reserving the first three colors for them means they keep the same color no matter what other tags you use.

Every other tag takes colors 4 to 8 in the order it first appears, reading down the first category's tag column (E8 to E19), then the second's (G8 to G19), and so on. This holds whether or not C, N and X are used on the template, so the first other tag is always color 4. A tag counts even when the cause beside it is empty. The sixth tag other than C, N and X starts again at color 1, so it shares its color with C, the seventh shares with N, and so on.

Because the order depends on where each tag first appears, adding, removing or moving a tag other than C, N or X can change the color of other tags that are not C, N or X.

Automatic is offered only when this Excel can do it. It needs the Excel functions LET, VSTACK, TEXTSPLIT, TOCOL, CHOOSECOLS, UNIQUE and FILTER. When the template is created in an Excel without them, the list in E5 offers only None and Manual.

Manual

Fill any tag cell with a color, using Excel's own Fill Color. On the next update each tag box takes the fill color its tag cell shows.

A tag cell with no fill, a white fill, or the template's own background shade (hex EEECE1) counts as uncolored, and its tag box gets the standard color used by None.

The Fishbone dialog

Opens when you run Fishbone Diagram from Template on a template that already has a diagram. It asks: This template already has a diagram. Would you like to update the existing diagram or create a new diagram?

Button What it does
Update brings every diagram made from this template up to date. This is the default button, so pressing Enter chooses it
Create New adds another diagram sheet made from this template
Cancel does nothing. Pressing Esc chooses it

When the workbook structure is protected, the dialog does not open, and the existing diagrams are updated, because a new sheet could not be added.

What Update reads

Update Diagram, and the Statistical Tools Update button on a Fishbone sheet, read the template as it stands: every cause, tag and category title, the output in E4 and the choice in E5. It has no settings of its own. The table of what it changes is on Fishbone.

See Also