In this article:

How to Make a Bell Curve in Google Sheets (2024 Guide)

May 8, 2024

How to Make a Bell Curve in Google Sheets

Below are the steps you can follow to create a bell curve in Google Sheets:

Step 1: Prepare Your Data

Start by opening a new Google Sheets document. In the first column (e.g., A1, A2, A3...), input a range of values that you want to use for your bell curve. This could be a series of numbers, like -3, -2, -1, 0, 1, 2, 3, representing standard deviations.

how to make a bell curve in google sheets

Step 2: Calculate the Bell Curve Values

In the next column (B), next to each value, use the NORM.DIST function to create the bell curve. This function requires four parameters:

  • x: The value for which you want the distribution (use the value from the first column).
  • mean: The mean of your distribution (often 0 for a standard bell curve).
  • standard_deviation: The standard deviation of your distribution (often 1 for a standard bell curve).
  • cumulative: FALSE for a standard bell curve.

For example, in cell B1, you might input: =NORM.DIST(A1, 0, 1, FALSE).

Click and drag the corner of the cell with the formula to apply it to all other cells in column B corresponding to your values in column A.

bell curve google sheets

Step 3: Create the Bell Curve Chart

Select the cells that contain your data in both columns. Go to the menu, click on “Insert”, then select “Chart”.

google sheets bell curve

In the Chart Editor on the right, under the "Setup" tab, choose “Line chart” or “Scatter chart” to create a bell curve.

bell curve in google sheets
how to create a bell curve in google sheets

You can adjust the chart title, axis titles, and other settings in the Chart Editor under the "Customize" tab.

Step 4: Finalize and Review

Ensure the chart looks like a bell curve, with a peak at the mean and tapering off on either side. If the chart doesn’t look right, you may need to adjust your data range or check your formula.

For a smoother curve, use more data points. For example, use increments of 0.1 (-3, -2.9, -2.8, …, 2.9, 3). Experiment with different means and standard deviations in the NORM.DIST function to see how they affect the shape of the bell curve.

We hope that this article has helped you and given you a better understanding of how to make a bell curve in Google Sheets. If you enjoyed this article, you might also like our articles on how to change the case of text in Google Sheets and adding images to Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->