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
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: Highlight the Chart Data
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: Choose the Chart Type
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.