How to plot sine wave in Excel?

Answer 1

One method of plotting a sine wave in Excel requires that you create two columns of data - the first corresponding to the 'x' axis of your chart, and another corresponding to the 'y' axis. The first column, which will represent the x axis data will typically be a list of equally spaced numbers that covers the range of the sine wave you are interested in. For example, one period of the sine function can be plotted with the following data points for the first column: Cell A1: 0 Cell A2: 0.79 Cell A3: 1.57 Cell A4: 2.36 Cell A5: 3.14 Cell A6: 3.93 Cell A7: 4.71 Cell A8: 5.5 Cell A9: 6.28 The second column, which will represent the y axis consists of the functions to create data points along the sine wave. These cells will contain formulas that calculate the sine function for each point given in the first column. The basic format of the formulas entered into the cells of the second column is "Cell Bx: =SIN(Ax)", where x is the row number. For example: Type the following formulas in the cells indicated. The equals sign tells Excel that the data in the cell is a formula and must be included. Cell B1: =SIN(A1) Cell B2: =SIN(A2) Cell B3: =SIN(A3) Cell B4: =SIN(A4) Cell B5: =SIN(A5) Cell B6: =SIN(A6) Cell B7: =SIN(A7) Cell B8: =SIN(A8) Cell B9: =SIN(A9) === === To create the graph select the two columns of data that were created, click on the "Chart" icon or select Insert>Chart, select an XY Scatter plot with smoothed lines, and click through to "Finish." The completed chart will appear on the workbook for further formatting. * To achieve greater resolution you can add more rows to both columns. Any number of rows can be added (within the limits of Excel). Just ensure that the formula entered in any cell in the second column follows the format in the example shown above.