How Do I Make A Boxplot In Microsoft Excel?

Asked By A Williams 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?

• Status: Open
• Question Views: 372
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By J Gabriel 0 points N/A #92906

How Do 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.

About J Gabriel

Questions
8

Answers
13

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 10/12/2016
• Question Category: MS Excel