Download Article
Use the S curve formula in Excel
Download Article
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
-
Enter your chart data. 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 1JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC 2New 54 62 74 390 420 90 800 151 220 130 145 280 3Total 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 .
-
Highlight the data. Be sure to include column and row headers. All selected data will be added to the chart.Advertisement -
Click the Insert tab. It's above the toolbar at the top of Excel. -
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."
-
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.
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
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
- 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
- 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
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
Advertisement
About This Article
Article Summary
X
To create a basic S curve in Excel, start by entering your data into your workbook. One line or column must be dedicated to a time (such as a row of months), and another should contain data that changed over that time period. Once entered, highlight the selected data and click the Insert tab. On the Charts panel, select a Line or Scatter chart to display your S curve. You can edit your chart using the icons to its right.
Did this summary help you?
Thanks to all authors for creating a page that has been read 393,020 times.
Advertisement
