Click the 'Insert' tab on the Excel ribbon, click the 'Scatter' drop-down menu from the 'Charts' group and select the 'Scatter with only Markers' option. Copying is done by clicking cell B1, pressing the Ctrl+C keys to copy, click and dragging cells B2 through B8, then pressing Ctrl+V to paste.ĭraw a graph for your data by click and dragging the cells containing the X and Y values closest to the point for which you want to calculate the tangent. If you're using a formula, such as 'y = 5 + sqrt(x),' enter '=5+sqrt(A1)' into cell B1, then copy and paste cell B1 to cells B2 through B8.
Create a column containing the Y values for your graph.
