How to Make an S-Curve in Excel

By Ron Price

An S-curve chart is easily generated with Excel, using time-related data and either a Scatter or Line chart.

In Microsoft Excel, the S-curve is included in two chart types: Scatter Chart and Line Chart. Using either of these, you can create an S-curve chart that plots the change in one variable in relation to another variable.

Step 1

Enter data on an Excel worksheet in adjacent rows or columns.

Open Excel and enter your data in a worksheet in either rows or columns. Whichever layout you use, if you have two variables, make sure they are matched by the same period of time.

Step 2

Using the mouse, click into the upper-left cell of the chart data range and while holding down the mouse button, drag the mouse over the data to be used to generate the S-curve chart.

Step 3

One of the choices for chart type is a 2-D Line chart.

You have some options concerning which chart type to use for an S-curve graph. An S-curve can be plotted in any of four chart types: a Scatter with Smooth Lines chart, a 2-D Line chart, a 2-D Line with Markers chart or a 3-D Line chart.


Although the S-curve graph shown in this article compares two variables against time, an S-graph can consist of only a single S-curve.