How to Make an S-Curve in Excel
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.
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.
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.
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.