Excel Statistics 18: Pareto Chart for Categorical Data See how to create

[stekelenburg9]

Thanks for uploading this!!!

[hookey1000]

that was so cool, thanks it really helped with my pareto homework plus my excell skills.

[MNOKSA]

u r the best

[ExcelIsFun]

I am glad that the videos help!

[sandy1983100]

Hey I wanted to point out that in this pareto graph the percentages on the left side should add up to 100% and not 120 %. I am a great fan your videos and thanks for sharing your knowledge with us!!!

[ExcelIsFun]

The 120% is just on the axis. The line stops at 100%

[sandy1983100]

Hey I wanted to point out that in this pareto graph the percentages on the left side should add up to 100% and not 120 %. I am great fan our videos and thanks for sharing !!!

[sandy1983100]

Hey I wanted to point out that in this pareto graph the percentages on the left side should add up to 100% and not 120 %. I am great fan our videos and thanks for

[danny90aner]

Subscribed! Thanks for helping! :-)

[ExcelIsFun]

You are welcome!

[Tote1883gas]

Really good, better than all the courses i have been on!! subscribed

[ExcelIsFun]

I am glad that you liked it!

[Tote1883gas]

@ExcelIsFun

There has to be a gap for you in the training market, your approach is refreshing and above all fun. Good luck, and keep uploading!

[ExcelIsFun]

Thanks! Yes, since it is free - the gap is big!!

[MrSachininHolland]

When you did the count of frequency, you already know that the # 1 reason of dissatisfaction is Bad Finish!! because the count was 20. So what did you conclude more after creating a Pareto Chart?

[ExcelIsFun]

Just a visual way of showing biggest first. Very old type of chart. Goes way back...

[LipperSucker]

You rock!! You saved my day!! You do a great job explaining this and you're fun to listen to. thanks!!

[ExcelIsFun]

I am glad that the video helped!

[gdareos]

I really found this extremely helpful. I especially like using CTL+1 to format the Secondary Axis. I did not know how to do this. Thanks very much.

[ExcelIsFun]

You are welcome!

[Mariam196]

hi im really confused the data labels yuo hsave of the intervals i ahve tried to do that also bt everytime i go into make a chart all 3 columns come nto the graph and not the intevals as the x-axis

[bmnair]

Very useful. Thank you Sir.

[ExcelIsFun]

You are welcome!!

[grendizer69]

@ExcelIsFun

LOL, you are a funny man. Thank you very much for this useful stuff. Subscribed!

[TTorance1]

As usual was helpful in statistics class, and now helpful when im in TQM :) ty sir

[ExcelIsFun]

You are welcome! I am glad it helps with TQM!

[arlesdufour]

simply amazing !!!

Your channel, your way to teach and the way you say parreto. Best useful channel ever !

[ExcelIsFun]

I am glad that you like it!!

[rolandocastrog]

Thx, this was really helpful!

[ExcelIsFun]

You are welcome!

[seng0111]

that's helpful.. thanks a lot..

[ExcelIsFun]

You are welcome!

[timabad]

"burrito burrito"

[metalhead7369]

awesome helped alot thanks man

[ExcelIsFun]

Dear metalhead7369,

You are welcome!

--excelisfun

[fortisglez]

This is excellent!! Thank you man! Just great!

[ExcelIsFun]

Dear fortisglez,

I am glad it is useful!

--excelisfun

[erick7a31]

hah cool man, it's helpful !

[ExcelIsFun]

Dear erick7a31,

I am glad that it was helpful!

--excelisfun