How to Make an S-Curve in Excel

Techwalla may earn compensation through affiliate links in this story.
Image Credit: Ron Price

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.

Advertisement

Step 1: Enter Data

Image Credit: Ron Price

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.

Video of the Day

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.

Advertisement

Step 3: Choose the Chart Type

Image Credit: Ron Price

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.

Tip

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.

Advertisement

references