How to Create an S Curve Pattern in Microsoft Excel

Use the S curve formula in Excel

Written by Nicole Levine, MFA

Last Updated: December 27, 2024

When creating an S curve, you'll always have one column or row dedicated to a time period, such as months, quarters, or years. Your other data (such as income, time, or money spent) will display as a "curve" over that time period, which can help you identify trends and target new strategies. This wikiHow article teaches you how to use Microsoft Excel to create an S curve.

Making an S-Curve in Excel

Dedicate one row or column for denoting the time period for your data.
Highlight the data, go to the Insert tab, and select either the Line or Scatter chart.
Customize the chart title, data labels, trendline, and more!

Steps

Download Article

Since an S curve shows data over a period of time, make sure to reserve one row or column for denoting the time period. For example, let's say you wanted to show an S curve of new accounts over the course of twelve months. It may look something like this:

New Accounts 2020
	A	B	C	D	E	F	G	H	I	J	K	L	M
1		JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
2	New	54	62	74	390	420	90	800	151	220	130	145	280
3	Total	54	116	190	580	1000	1090	1890	2041	2261	2391	2536	2816

In this example, the formula we use to get the value of C3 (The February cumulative total of 116) is =B3+C2, which adds the monthly sign-ups from February to the previous cumulative amount of 54. Similarly, the March cumulative total is calculated using =D2+C3.

Be sure to include column and row headers. All selected data will be added to the chart.

Advertisement
It's above the toolbar at the top of Excel.
4
Select a chart type. You'll see several icons and menus in the "Charts" panel at the top of Excel, and hovering your mouse cursor over them will display what kind of charts are inside. You can create an S curve on a Line or Scatter chart.^{[1]
X
Research source} Once you select a chart, your S curve will appear, illustrating growth and loss over time.
- To see your line as a nice smooth curve, go with a Scatter chart. To do this, click the icon with several blue and black dots scattered over a right angle, and then select the Scatter with Smooth Lines option.
- To insert a regular Line chart (it won't be smooth/curved but it definitely displays the correct data on a line), click the icon with overlapping blue and black lines with dots at each point. You can then choose any of the charts in the "2-D Line" or "3-D Line section."
5
Customize your chart. Now that your S curve appears on the chart, you can edit it as you see fit.
- To edit the title of your chart, double-click Chart Title and type a new name.
- Click the + next to your chart to customize elements. Some especially helpful elements you might edit are Data Labels (to plot the values on the curve), Data Table (to show the raw data at the bottom), and Trendline (to show trends on any variable).
- Click the paintbrush icon next to your chart to choose different styles and colors. Some of the different styles provide additional helpful information for interpreting your data.
- Click the funnel icon next to the chart to choose which data you want to see on your chart. For example, if you only want to see the S curve for cumulative data, you can remove the checkmark from the monthly entries.

Expert Q&A

Search

Add New Question

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Tips

Depending on the type of chart you select, your S curve line may be more angular than curved. This doesn't mean the data is inaccurate.

Thanks
Helpful 0 Not Helpful 0
If you don't want to select all data for the chart, hold down the Ctrl or Command key as you click the cells you do want to add instead.

Thanks
Helpful 0 Not Helpful 0
Check out https://stats.areppim.com/calc/calc_scurve.php to learn how to create an S curve with a generator rather than Excel data.

Thanks
Helpful 0 Not Helpful 0