# 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

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