How to Make a Curve Graph in Excel

Creating a curve graph in Excel lets you visualize trends, growth patterns, and non-linear relationships that a simple straight line just can't capture. It's perfect for showing how data changes gradually or follows a specific distribution. This guide provides step-by-step instructions for three different ways to make a curve graph, from basic smoothed lines to statistical bell curves.

What is a Curve Graph and Why Use One?

An angular, connecting-the-dots line graph is great for showing changes from one distinct point to another. But often, the story your data tells is more fluid. A curve graph uses a smoothed line to represent data, which is ideal for a few key scenarios:

• Visualizing Gradual Change: Showing metrics that don't jump abruptly, like product adoption over time, temperature changes, or natural growth cycles.
• Illustrating Projections and Trends: A curved trendline can show the underlying pattern in scattered data points, helping you forecast sales, website traffic, or resource requirements.
• Displaying Statistical Distributions: The classic bell curve, or normal distribution curve, is essential for visualizing how data is spread around a central average, great for things like exam scores or manufacturing tolerances.

Unlike a "Bar Chart" or "Pie Chart," there isn't a single button in Excel called "Curve Graph." Instead, you create one by choosing the right chart type and formatting options. Let's walk through the three most common methods.

Method 1: Create a Basic Smoothed Line Chart

This is the quickest and easiest way to turn a standard line graph into one with smooth curves. It's best used when your data points represent a continuous flow, and you want to visually soften the sharp angles between data points.

Step 1: Set Up Your Data

First, organize your data in two columns. The left column will be your X-axis (horizontal axis), typically representing time (days, months, years) or another independent variable. The right column will be your Y-axis (vertical axis), representing the values you want to measure.

Here’s a simple example tracking monthly website visitors:

• Column A: Month (Jan, Feb, Mar, etc.)
• Column B: Visitors (12000, 13500, 15200, etc.)

Step 2: Insert a Scatter with Smooth Lines Chart

This chart type is designed to create a curved visual right from the start.

• Select all of your data, including headers (e.g., A1:B13).
• Navigate to the Insert tab on the Excel ribbon.
• In the Charts group, click the "Insert Scatter (X,Y) or Bubble Chart" icon.
• From the dropdown menu, choose "Scatter with Smooth Lines."

Excel will instantly generate a chart with a smooth, flowing curve connecting your data points.

Alternative: Smoothing an Existing Line Chart

Maybe you already have a standard line chart and just want to make it curvy. That's easy, too.

• Start by creating a standard line chart (Insert > Line or Area Chart > Line with Markers). You'll get straight lines and sharp angles.
• Right-click on the data line within your chart and select "Format Data Series...".
• A formatting pane will open on the right side. Click the "Fill & Line" icon (paint bucket).
• Expand the "Line" options if they are not already open.
• At the bottom, check the box for "Smoothed line."

Your jagged line will immediately transform into a gracefully curved graph.

Method 2: Add a Curved Trendline to Your Data

Sometimes your data is "noisy" or scattered, and connecting the dots doesn’t reveal the true pattern. Adding a best-fit curved trendline is more useful. This method doesn't connect each point directly but generates a single curved line that best represents the overall trend.

Step 1: Create a Scatter Plot

A trendline works best over a scatter plot showing raw data points.

• Select your X and Y axis data.
• Go to the Insert tab.
• Click the "Insert Scatter (X,Y) or Bubble Chart" icon and choose "Scatter."

You’ll get a chart that shows just the raw plot points. Now, we’ll add a curve through them.

Step 2: Add and Format the Trendline

• Click on your scatter plot to select it. A "+" icon (Chart Elements) should appear.
• Click the "+" icon, hover over "Trendline," and then click the small arrow that appears.
• Select "More Options…". This opens the "Format Trendline" pane.

Here, choose the type of curve that best fits your data. For creating a smooth curve, avoid the "Linear" option. Useful options include:

• Logarithmic: For data that rises or falls quickly initially then levels off.
• Polynomial: Very flexible. You can set the "Order" (e.g., 2 or 3). A quadratic (Order 2) gives a simple bend, a cubic (Order 3) can form an S-shape.
• Power / Exponential: For data growing or declining rapidly.

Select "Polynomial" and set Order to 2 or 3 to start. Excel will generate a smooth trendline showing the overall pattern.

Pro Tip: At the bottom of the Trendline options, check "Display R-squared value on chart". This indicates how well the trendline fits your data (closer to 1 is better).

Method 3: Build a Bell Curve (Normal Distribution)

This is a more advanced graph used in statistics to show the data distribution. Creating it involves calculations, but it visually shows where most data points cluster.

Step 1: Calculate Mean and Standard Deviation

Start with your dataset (e.g., test scores, weights). Assume data is in cells D2:D50.

Calculate:

• Mean: =AVERAGE(D2:D50)
• Standard Deviation: =STDEV.S(D2:D50)

Store these in separate cells for easy reference.

Step 2: Set Up the Bell Curve Data Table

Generate X and Y points.

• Column 1: Range of values covering ±3 standard deviations from the mean (e.g., for mean=80, std=5, range from 65 to 95).
• Column 2: Use =NORM.DIST(A2, mean_cell, std_cell, FALSE) for each X value (A2).

Drag this formula down across your range of X values.

Step 3: Graph Your Bell Curve

• Select your X values and corresponding NORM.DIST results.
• Go to Insert > Scatter with Smooth Lines.
• Choose "Scatter with Smooth Lines."

Excel will plot the points and connect them into a smooth bell curve, illustrating the data distribution.

Final Thoughts

Whether smoothing a line, modeling a trend, or visualizing a distribution, Excel has the tools you need. Match your method to your data for clear, accurate visuals.

While creating these graphs manually is valuable, automating the process saves time. We built Graphed to connect your data sources like Google Analytics, Shopify, or Salesforce, and generate live dashboards instantly—no formulas or formatting required.