The answer is too complicated to show here, without examples, so click on the related links for information to point you in the right direction.
Chat with our AI personalities
Excel does not have a native BOXPLOT function, but you can replicate the function by following the instructions in the related links.
How do you make a stem and leaf plot
The plot area walls and chart area in Excel can easily be customized. This can be done by applying predefined shape styles to the area. You can also apply shape outlines and shape fills.
=TriangularRand(20,40,60)
It allows you to make charts or graphs. You will find it in the Charts section of the Insert Ribbon in Excel 2007.