logo
logo
Sign in

How to Create a Box Plot in Excel

avatar
ava williams
How to Create a Box Plot in Excel

Box plots is a very convenient way to get the data distribution in Excel. But, Microsoft Excel does not include the box plot chart template. Do you want to create a box plot in Excel? Then follow the instructions mentioned below.

Steps to create a box plot in Excel

  1. Type the title for every section.
  2. For using the example data, type 2017 in D3 column.
  3. After that, type 2018 in E3 column.
  4. You need to type the data in the cells in every section.
  5. Save the worksheet.

Steps to type the plot chart formulas

  1. Select where you wish to type the formulas.
  2. You need to do this procedure for calculating the quartile values.
  3. The columns given in the table will include the below-mentioned data:
  • First quartile
  • Median value
  • Third quartile
  • Minimum value
  • Maximum value
  1. Type the given formula =MIN (cell range) in the cell given on the top of the list.
  2. Type the given formula =QUARTILE.INC (cell range, 1) in the next cell.
  3. Type the given formula = MAX (cell range) in the cell given in the next column.
  4. Start copying the formulas in the next section.
  5. In case the data has more than one section, then you need to start copying the formula in the different rows which table includes.

Steps for calculating quartile differences

  1. Select where you wish to type the formulas for calculating the quartile values.
  2. By going to the cell given on the upper side of the menu list, type the minimum value for the first section.
  3. Search for the differences between the minimum value and top quartile.
  4. Start copying the formulas by going to the cells.
  5. Start saving the changes you have made.

Steps for creating the stacked bar chart in Excel

  • Choose the data by going to the table located in the third column.
  • Select the Insert option.
  • Click on the Insert Column Chart option.
  • Choose the Stacked Column option.
  • You need to right-click on the chart.
  • After that, select the Select Data option.
  • Now, you will get the Select Data Source prompt box on the screen.
  • Choose the Switch Row or Column option.
  • It is located in the middle of the prompt box.
  • Select the OK button.
  • Source url:-   https://williamsblogpoint.wordpress.com/2019/08/28/how-to-create-a-box-plot-in-excel/

Ava Williams is a creative person who has been writing blogs and articles about cyber security. She writes about the latest updates regarding mcafee.com/activate and how it can improve the work experience of users. Her articles have been published in many popular e-magazines, blogs and websites.

collect
0
avatar
ava williams
guide
Zupyak is the world’s largest content marketing community, with over 400 000 members and 3 million articles. Explore and get your content discovered.
Read more