Need to Create a Love Bug Diagram but Don't Know How?

QI Macros has a Ready Made Love Bug Template in Excel!

Use a love bug diagram to identify factors that contribute to an event, incident or defect and those that work to prevent them.

The Love Bug diagram combines two fishbone diagrams. The fishbone on the left documents factors that cause or contribute to an event. The fishbone on the right documents factors that work to prevent an event from occurring.

love bug diagram in excel

To access QI Macros Love Bug Diagram, click on QI Macros menu > Improvement Tools > Ishikawa Fishbone Diagram.

fishbone excel menu

Once the Fishbone template is open, select the "Love Bug Diagram" tab at the bottom of the spreadsheet:

lovebug-diagram-tab


Analyze root causes like you would for a fishbone diagram.

  1. Put the problem statement in the head of the fish and the major causes at the end of the major bones. Major causes include:
    • Processes, machines, materials, measurement, people, environment
    • Steps of a process (step 1, step 2, etc.)
    • Whatever makes sense
  2. Begin with the most likely main cause.
  3. For each cause, ask "5 Whys."
  4. lovebug-diagram ask five whys

  5. Circle one-to-five ROOT causes (end of the "5 whys" chain).
  6. Verify the root causes with data (Pareto chart or Scatter Diagram).

Stop Struggling with Love Bug Diagrams!
Start creating your Love Bug Diagrams in just minutes.

Download a free 30-day trial. Get Love Bug Diagrams now!

QI Macros Draws These Charts Too!