In this post will be discussed on how to graph cosine in excel 2007 (special for beginner). Please follow the procedures of cosine graph below:
1. In an excel worksheet create data like below
Column A in the range A3: A27 is filled with angle data (in units of degrees), starting from zero up to 360 with intervals of 15 degrees.
Column B is filled with a formula to calculate the cosine of the angle contained in column A
in cell B3 enter the formula "= COS (radians (A3))" without quotes
Copy the formula in cell B3 up to B27
2. To get started create a chart, Block range A3: B27
On the menu bar choose Insert - Scatter - "Choose one of the main scatter model (see figure below)"
3. If the process succeeds then graphics cosine (cosine curve) will appear as below
If you interest with this tutorial, Sample files can be downloaded here cosine curve