How to Create an Excel Box and Whisker Chart (Excel Box Plot)

[CampbelltoeMcintosh]

thankyou!

[LissadelSol]

Great tutorial, very helpful! Thank you!

[poolkfg]

hi, when I stack them like you do I get it all on one bar. I m using 2010. Is there anything I can do?

[34kakalo]

Your voice makes me want to shoot myself

[Japindian92]

@34kakalo you mean jack off

[MsBammerz]

sorry if this is a stupid question... but why are the min and max's on the bottom different? like the first min is 4.0 and the second min is 3.5, same as for max

[contextures]

@MsBammerz The first Min and Max are the actual values, and the second set of Min and Max are the length of the whiskers, that show the Min and Max.

If you click the link in the description, you'll see my blog article about this box and whisker chart. In that article, the second screen shot shows the formulas for those Min and Max calculations.

[Recog666]

Thanks so much... my teacher is useless. This help me finish my assessment thanks a lot

[contextures]

@Recog666 Thanks, glad it helped with your school work.

[lolita901127]

Actually the method you are presenting is WRONG since it wont be applicable for all kinds of data. YOU ARE SUBJECTIVELY ASSUMING ALL THE DATA SELECTED IS POSITIVE. If there were negative values in another data set, your method wouldnt work because the value you set up for Q1 would be the lengh of bar area below x-axis, and sequently all the median, Q3, Max value wouldnt be correct. Better revise it otherwise this video could be quite MISLEADING

[Arthurcoloccini]

Thank you, great tutorial, you save my life,

[ducksaj]

Hello, I think if you dont know nobody does, so, is there a way to create a macro to set up the macro security level to "down" automatically, because threre are many users dont know how to do it, thank you very much

[contextures]

@ducksaj No, you can't changed the user's macro settings by running a macro.

You could add an instruction sheet at the front of the workbook, and explain how to enable macros in the Excel file. Proficient users could ignore that sheet, and those who need help could follow your written instructions to enable macros.

[ducksaj]

@contextures so.....thank you for your prompt atention