Customizing the Fishbone Diagram

How to Fine Tune Your QI Macros Fishbone

QI Macros fishbone diagram excel

Since we couldn't anticipate every fishbone you might create (imagine every tree in your neighborhood), you may want to customize various aspects of the fishbone diagram:

  • Size and depth of text boxes (just click on the box and resize it)
  • Shape of the arrows (just click on the arrow and stretch or resize it)
  • Positioning of the arrows or text boxes (just click on the box or arrow and then drag it to the new position.

How to Customize QI Macros Automated Fishbone DiagramĀ 



  1. Put desired texted into the unused "Whys" on the Outline sheet
    Unused Whys on Fishbone Diagram
  2. Refresh the Fishbone Diagram using the Create Fishbone Button
    Create Fishbone button
  3. Move the new arrows and text to the desired location
    Click and Drag Fishbones and Text
  4. Result
    Customized Fishbone Diagram

How to Customize QI Macros Manual Fishbone DiagramĀ 

  1. Use Select Objects to select the bones you want to copy
    Select objects in Excel Select bones on Fishbone diagram - QI Macros
  2. Copy the bones
    Copy bones on QI Macros Fishbone Diagram
  3. Paste the bones and drag them to where you want to use them
    Paste bones onto a QI Macros Fishbone Diagram
  4. Modify the text in the bones.

You can also do this for the automated fishbones, but text boxes must be modified manually. If you end up with too many bones, you may be doing a "Whalebone" diagram which means that the problem wasn't stratified enough using Pareto charts. You may need to back up and narrow your focus.

Learn More...

Create these charts and diagrams in just seconds using QI Macros for Excel...
Try It Now!