How Do I Make A Boxplot In Microsoft Excel?
Asked By
30 points
N/A
Posted on - 10/12/2016
I have got some data in a tabular format. I want to create a box and whisker chart for it. How can I make a BoxPlot in Microsoft Excel?
I have got some data in a tabular format. I want to create a box and whisker chart for it. How can I make a BoxPlot in Microsoft Excel?
To create a BoxPlot in Microsoft Excel, follow the following steps:
1. Select your date in whichever format you have it in MS-Excel.
2. Click on Insert tab on the top and click on “Insert Statistics Chart” and select Box and Whisker from the drop-down menu.
3. Use the Format tab to customise the look of the chart.