0:02 in this video I'm gonna show you
0:04 step-by-step how to make the perfect
0:18 petal chart okay guys let's get started
0:21 so I've very set up I've pre-populated a
0:23 little data table here
0:26 these are defect types for a shirt okay
0:28 now the first step we're gonna want to
0:31 do is sort the total defects from
0:35 largest to smallest so highlight your
0:39 column B go over to data go to sort
0:44 press the arrow and select descending
0:46 this will give you a warning here you
0:48 want to make sure it's selected expand
0:50 the selection press sort
0:53 now you'll see that button defect is our
0:55 winner it's got the most defects and zip
0:58 or defect is the least that number one
1:01 on our next column we're gonna assign a
1:11 percentage of the total so this will be
1:19 this cell divided by sum of the total
1:22 number of defects okay now before I
1:24 press ENTER I want to put a dollar sign
1:26 in front of the two and the dollar sign
1:28 in front of the eleven and this will
1:31 prevent when I drag this formula down
1:33 it'll prevent those numbers from
1:37 changing so if you get a decimal point
1:40 no problem just go up here to percentage
1:41 Press that and it'll change it into a
1:44 percentage for you now you want to drag
1:47 the cell all the way down and we've
1:50 calculated our total percentages of each
1:55 defect type the next step is we want to
1:57 get the percentage the cumulative
2:03 percentage okay let's let make these
2:06 look a little bit nicer we can wrap these
2:13 so to get the cumulative percentage so
2:16 your first value is just going to be
2:19 this value here so you can just have it
2:23 equal to sell so for this value here and
2:25 you want to write the formula is gonna
2:32 be sum of these two cells now before you
2:33 close it you want to put a dollar sign
2:35 in front of the two there because you
2:38 want to lock that two and I'll show you
2:41 why in a moment okay so now when we drag
2:43 this down to get the cumulative
2:46 percentage okay you'll see that it
2:50 equals to 100 your two won't change but
2:54 your this value here on your will change
2:55 and it'll give you a cumulative
2:58 percentage value okay so now that we got
3:02 our numbers total numbers here we'll
3:07 highlight our table go to charts select
3:13 column clustered column chart here okay
3:15 make that a little bit bigger for you
3:19 guys so you can see okay now the first
3:22 step is you want to highlight your click
3:25 your graph go to select under the data
3:29 here select go to total percentage and
3:30 you can remove that because we don't
3:34 really need to see that so click remove
3:38 okay now your cumulative percentage data
3:41 series select that here
3:44 okay see how I've selected it right
3:48 click it it's a little bit tricky
3:50 sometimes right click it and go to
3:53 format data series you like this video
3:55 so far smash that like button and
4:00 subscribe thanks and then you want to go
4:03 to the axe seesaw option and change it
4:07 to secondary axis okay we're not done
4:09 yet hold on so leaving it selected what
4:12 you want to do is you want to change you
4:14 want to make sure it's still selected
4:18 here go to line because you want to
4:20 change we're going to change the the
4:21 chart type
4:25 okay change it to a line and you'll see
4:27 that this line as you go along your
4:29 defects the line adds up to the end it's
4:33 a hundred percent of your defects okay
4:36 now we'll add a little we'll go to chart
4:38 layout will add our titles go to axis
4:41 titles so first of our primary vertical
4:45 axis okay
4:54 okay then we want to add our go back to
4:56 axis titles after second our secondary
5:01 vertical axis title and that'll be our
5:08 cumulative percentage okay every chart
5:11 has a really good title hey guys before
5:14 I finish check out my description below
5:17 for some video notes and also leave a
5:19 comment if you have any questions or
5:21 have any good ideas or suggestions for
5:34 future videos so feretto chart defects
5:36 so when you present this data to
5:39 management it's very easy to show that
5:42 you know if we go from 80 percentage
5:45 here and we draw a line down here more
5:47 or less we can see that you know 20 to
5:50 30 percent of our defect types are
5:55 causing 80 percent of our problems okay
5:58 and that's how you create a perfect
6:00 prototype if this was helpful stick
6:03 around and check more of my other videos [Music]
Chrome Extension