If you select a Line chart you will get one of the following charts. Use the ymxb formula. That equation includes a slope and intercept value.
That adds r squared to the graph just below the equation as in the snapshot below.
To graph a linear equation all you have to do it substitute in the variables in this formula. Y sinx The following image shows how to create the y-values for this equation in Excel using the range of 1 to 10 for the x-values. Use the ymxb formula. That adds r squared to the graph just below the equation as in the snapshot below.