How to create Fishbone Diagram using a spreadsheet (Microsoft Excel)?

Six Sigma White Belt: Learn Six Sigma & Grow Your Potential Six Sigma White Belt: Understanding the Seven Basic Tools of Quality
6 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$49.99
List Price:  $69.99
You save:  $20
€47.52
List Price:  €66.54
You save:  €19.01
£39.70
List Price:  £55.59
You save:  £15.88
CA$70.43
List Price:  CA$98.62
You save:  CA$28.18
A$76.97
List Price:  A$107.77
You save:  A$30.79
S$67.31
List Price:  S$94.24
You save:  S$26.93
HK$389.04
List Price:  HK$544.69
You save:  HK$155.65
CHF 44.26
List Price:  CHF 61.97
You save:  CHF 17.70
NOK kr555.31
List Price:  NOK kr777.48
You save:  NOK kr222.17
DKK kr354.52
List Price:  DKK kr496.36
You save:  DKK kr141.83
NZ$85.39
List Price:  NZ$119.56
You save:  NZ$34.16
د.إ183.61
List Price:  د.إ257.07
You save:  د.إ73.46
৳5,974.85
List Price:  ৳8,365.27
You save:  ৳2,390.42
₹4,214.36
List Price:  ₹5,900.44
You save:  ₹1,686.08
RM223.20
List Price:  RM312.50
You save:  RM89.30
₦84,139.66
List Price:  ₦117,802.26
You save:  ₦33,662.60
₨13,894.72
List Price:  ₨19,453.72
You save:  ₨5,559
฿1,731.75
List Price:  ฿2,424.59
You save:  ฿692.84
₺1,731.89
List Price:  ₺2,424.79
You save:  ₺692.89
B$291.02
List Price:  B$407.45
You save:  B$116.43
R904.37
List Price:  R1,266.19
You save:  R361.82
Лв93.24
List Price:  Лв130.55
You save:  Лв37.30
₩69,838.35
List Price:  ₩97,779.29
You save:  ₩27,940.93
₪182.45
List Price:  ₪255.44
You save:  ₪72.99
₱2,948.07
List Price:  ₱4,127.53
You save:  ₱1,179.46
¥7,686.27
List Price:  ¥10,761.39
You save:  ¥3,075.12
MX$1,026.34
List Price:  MX$1,436.97
You save:  MX$410.62
QR181.99
List Price:  QR254.80
You save:  QR72.81
P683.05
List Price:  P956.33
You save:  P273.27
KSh6,473.70
List Price:  KSh9,063.70
You save:  KSh2,590
E£2,479.91
List Price:  E£3,472.08
You save:  E£992.16
ብር6,171.26
List Price:  ብር8,640.26
You save:  ብር2,469
Kz45,640.87
List Price:  Kz63,900.87
You save:  Kz18,260
CLP$48,800.23
List Price:  CLP$68,324.23
You save:  CLP$19,524
CN¥362.21
List Price:  CN¥507.13
You save:  CN¥144.91
RD$3,019.39
List Price:  RD$4,227.39
You save:  RD$1,208
DA6,681.78
List Price:  DA9,355.03
You save:  DA2,673.24
FJ$114.89
List Price:  FJ$160.86
You save:  FJ$45.96
Q386.07
List Price:  Q540.54
You save:  Q154.46
GY$10,461.05
List Price:  GY$14,646.31
You save:  GY$4,185.25
ISK kr6,897.62
List Price:  ISK kr9,657.22
You save:  ISK kr2,759.60
DH501.57
List Price:  DH702.24
You save:  DH200.67
L910.90
List Price:  L1,275.33
You save:  L364.43
ден2,944.65
List Price:  ден4,122.75
You save:  ден1,178.09
MOP$400.69
List Price:  MOP$561
You save:  MOP$160.31
N$901.81
List Price:  N$1,262.61
You save:  N$360.80
C$1,837.63
List Price:  C$2,572.83
You save:  C$735.20
रु6,744.61
List Price:  रु9,443
You save:  रु2,698.38
S/189.86
List Price:  S/265.82
You save:  S/75.96
K201.24
List Price:  K281.76
You save:  K80.51
SAR187.73
List Price:  SAR262.83
You save:  SAR75.10
ZK1,378.75
List Price:  ZK1,930.37
You save:  ZK551.61
L236.54
List Price:  L331.18
You save:  L94.63
Kč1,201.96
List Price:  Kč1,682.84
You save:  Kč480.88
Ft19,552.70
List Price:  Ft27,375.34
You save:  Ft7,822.64
SEK kr547.88
List Price:  SEK kr767.08
You save:  SEK kr219.19
ARS$50,310.58
List Price:  ARS$70,438.83
You save:  ARS$20,128.25
Bs346.77
List Price:  Bs485.51
You save:  Bs138.73
COP$219,940.74
List Price:  COP$307,934.64
You save:  COP$87,993.89
₡25,482.47
List Price:  ₡35,677.50
You save:  ₡10,195.02
L1,260.99
List Price:  L1,765.49
You save:  L504.50
₲389,563.28
List Price:  ₲545,419.77
You save:  ₲155,856.48
$U2,130.69
List Price:  $U2,983.14
You save:  $U852.45
zł205.15
List Price:  zł287.23
You save:  zł82.07
Already have an account? Log In

Transcript

This session is about how to create a fishbone diagram. Creating a fishbone diagram is actually a two step process. Step number one is to conduct a brainstorming session. And then step number two is then to create a fishbone diagram. Let us look at each of these steps. Conducting a brainstorming session happens to be the number one step before we create the fishbone diagram.

When you're conducting a brainstorming session, you have to call the subject matter experts of the process together in one conference room. And on a whiteboard or a blackboard faces the availability you have to write down the issue that you're trying to tackle at the top as the headline as a facilitator, you are required to let people in the room know that they are here to gather the root causes that are contributing to this problem. Once they understand the problem, you have to request all of them to start contributing ideas of what could be the potential root causes for this problem to occur, we have created an example for you. Let's say if I'm going ahead and conducting a brainstorming session with a team of subject matter experts right in front of me for an issue of hi handle time off a call. Then in that case, the team would come with a lot of different issues which I will write on the board Those issues could be that there is an extreme surge in volume, there could be attrition of old people on the floor, there are certain shut down of systems due to which the volumes rise when the systems are up again, there is political unrest in the local area or in the city.

And due to that political unrest, people are not able to employees are not able to come to office due to which only a few employees are taking those calls and the wait time is high, leading to high average handle time. Some of the procedures are not defined very clearly, there are governance issues on the floor feedback is not given to the people who are taking call. So they are not aware of what mistakes they are doing. The processes are not standardized. So these are some of this total output that we receive once the brainstorming session is conducted. Now, we have this data as an unstructured data.

Our next step is to structure this data in the best possible manner. If you're using a generic fishbone diagram, it will have a common set of categories. These categories are generally called out as five m, five M stands for man, method, machine, material and Mother Nature. So, for example, if job knowledge is one of the root causes, then job knowledge is related to man. If processes are not standardized, then that is related to the method if the file cannot be opened And that is related to the material. If the systems are slow, then that is related to machine.

If there is absenteeism due to political unrest in the city or there is high attrition because some other company has come in the same city which is poaching the employees of our organization or if there is certain shutdown of systems, all of them will go under the category of Mother Nature. We have bifurcated the previous root causes already in our next slide. This is how it would look. Now, that you have bifurcated each of the root causes into these five different categories, it is time to put these root causes in this diagram. So, you will write the main issue as The high average handle time as the eye of the fish, you would define each of the categories as the sub bones of the fish such as man is one of the sub bones muttered machine material and Mother Nature. And then there would be further sub bones for each of these categories, which would come out of the table that we created in the previous slide.

And finally, your fishbone diagram would look something like this. This is how easy a fishbone diagram is to create. What we are able to easily see is how high average handle time is getting impacted by various root causes. This is a perfect visual representation of all the root causes in one The slide Thank you for listening

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.