Love Bug Diagram

Use it to identify factors contributing to and working to prevent an event, incident or defect.

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 the Love Bug Diagram, open the Fishbone Diagram found in the Improvement Tools drop-down menu:

fishbone excel menu

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


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).

Learn More...

Why Choose QI Macros Over Other Six Sigma Software?



  • Only $349 USD - less with quantity discounts
  • No annual subscription fees
  • Free technical support

easy to use

Easy to Use

  • Works right in Excel
  • Create a chart in seconds
  • Easy to customize & share charts

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free