How to Plot Normal Distribution in Excel (With Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

Excel is a powerful software. We can perform numerous operations on our datasets using Excel tools and features. With the help of various charts and graphs, you can effectively present survey results. Sometimes, we perform mathematical operations in Excel. They can include Statistics at times. The Normal Distribution comes along whenever dealing with Statistics. This article will show you the step-by-step procedures to Plot Normal Distribution in Excel.

Introduction to Normal Distribution

The Normal Distribution is also known as the Gaussian Distribution. It is a probability distribution of data that is symmetric to the mean. We need the Mean and Standard Deviation of the data first to calculate the Normal Distribution. The Mean is the average value of all data. The Standard Deviation measures the deviation of a particular data from the mean value.

How to Plot Normal Distribution in Excel: Step-by-Step Procedures

We’ll use the NORM.DIST function to find the Normal Distribution in Excel. This function needs 4 arguments.

x: The data for which we’ll determine the normal distribution.

mean: The average value of the dataset.

standard_dev: Measured standard deviation of the dataset.

cumulative: TRUE represents the cumulative distribution function. FALSE represents the probability mass function.

To illustrate, we’ll consider the below dataset as an example. For instance, the dataset contains Student Names and the obtained Marks. Now, go through the steps below carefully to determine the Normal Distribution of the Marks in Excel. Then, we’ll plot it.

STEP 1: Find Mean & Standard Deviation

Let’s calculate the Mean & Standard Deviation in our first step. We’ll apply the AVERAGE function to find the mean. Then we’ll insert the STDEV function to get the standard deviation.

  • First, merge the cell range D5:D12.
  • Then, in cell C5, type the formula:
  • Subsequently, press Enter.
  • Thus, it’ll return the Mean.

  • Similarly, merge the range E5:E12.
  • After that, type the below formula in cell E5:
  • Press Enter.
  • Hence, you’ll get the Standard Deviation.

Read More: Plot Normal Distribution in Excel with Mean and Standard Deviation

STEP 2: Create Normal Distribution Chart

We have to find the normal distribution points for each mark.

  • Firstly, click cell F5.
  • Now, insert the formula:
  • Next, press Enter.
  • You’ll get the normal distribution point for cell C5.

  • Afterward, use the AutoFill tool to complete the series.
  • As a result, it’ll return all the values.

Read More: How to Create a Distribution Chart in Excel 

STEP 3: Plot Normal Distribution in Excel

In this step, we’ll demonstrate how to plot normal distribution in Excel.

  • In the beginning, select the Marks range C5:C12.
  • Next, choose Home ➤ Editing ➤ Sort & Filter ➤ Sort Smallest to Largest.

plot normal distribution in excel

  • Consequently, a warning dialog box will pop out.
  • Check the circle for the second option.
  • Then, press Sort.
  • See the following picture to understand better.

plot normal distribution in excel

  • Thus, it’ll return the sorted marks column.

plot normal distribution in excel

  • Again, select Insert ➤ Insert Scatter or Bubble Chart ➤ Scatter with Smooth Lines.

plot normal distribution in excel

  • As a result, you’ll get the normal distribution graph.
  • The below figure demonstrates the outcome.

plot normal distribution in excel

STEP 4: Modify Chart

To make the Normal Distribution chart more presentable, we’ll perform some changes.

  • Double-click on the Chart Title. Rename it as Normal Distribution Graph.
  • Click on the chart. Press the + symbol present beside the chart as shown below.
  • Check the boxes for Axes, Axis Title and Chart Title.
  • To remove the gridlines, uncheck the Gridlines box.

plot normal distribution in excel

  • Now, double-click the Y-axis.
  • As a result, the Format Axis pane will appear.
  • Set the Minimum Bounds as 60.

plot normal distribution in excel

  • Similarly, double-click the normal distribution curve line.
  • Consequently, you’ll get the Format Data Series pane.
  • Check the circle for Built-in Marker Options.

plot normal distribution in excel

Final Output

After performing all the modifications, our Normal Distribution graph is finally ready to demonstrate. The below figure is the final output.

plot normal distribution in excel

Read More: How to Create a Probability Distribution Graph in Excel 

Things to Remember

  • To avoid errors, sort the data before plotting the normal distribution.
  • The mean and standard deviation should be in numbers.
  • To avoid #NUM! Error, make sure the standard deviation is greater than zero.

Download Practice Workbook

Download the following workbook to practice by yourself.


Henceforth, you will be able to Plot Normal Distribution in Excel following the above-described procedures. Keep using them. Let us know if you have more ways to do the task. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.

Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Aung Shine
Aung Shine

My name is Aung. I have my B.Sc. degree in EEE. From now on, I will be working with Microsoft Excel and other useful software, and I’ll upload articles related to them. My current goal is to write technical contents for anybody and everybody that will make the learning process of new software and features a happy journey.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF