How to Create an S Curve Pattern in Microsoft Excel

An S (sigmoid) curve is a visual representation of data over time. 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 minHour teaches you how to use Microsoft Excel to create an S curve.

Steps

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 2020ABCDEFGHIJKLM1JANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDEC2New546274390420908001512201301452803Total5411619058010001090189020412261239125362816

  • 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.

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. 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.

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.
  • 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.
  • 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.

Leave a Comment