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.
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. "
To edit the title of your chart, double-click Chart Title and type a new name. Click the + next to your chart to customize elements. Some especially helpful elements you might edit are Data Labels (to plot the values on the curve), Data Table (to show the raw data at the bottom), and Trendline (to show trends on any variable). Click the paintbrush icon next to your chart to choose different styles and colors. Some of the different styles provide additional helpful information for interpreting your data. Click the funnel icon next to the chart to choose which data you want to see on your chart. For example, if you only want to see the S curve for cumulative data, you can remove the checkmark from the monthly entries.
