![]() ![]() Step 10 - In Step 3 of 4 of the Chart Wizard, Chart Options, I added a title using the Title tab and took the check mark out of the Show Legend box at the Legend tab. Press the Next button at the bottom of the Chart Wizard window. There is nothing to change in the window. Step 9 - The next window is the Source Data window (Step 2 of 4 in the Chart Wizard). Step 8 - Click the Next button at the bottom of the Chart Wizard window. As long as you leave the mouse button depressed, you will see the sample graph produced from the data used. To see what the chart will look like, click on the button that says Press and Hold to View Sample. Step 7 - Select XY (Scatter) as the chart type. Step 6 - Click on the Chart Wizard button or choose Chart from the Insert menu. All data between the clicks is highlighted. An easy way to highlight data is to click one time on the top left number, hold down the Shift key, and with the Shift key depressed, click on the bottom right number. Step 5 - Highlight the data to be turned into a chart. When the cursor turns to a black plus, depress your left mouse button and drag down even with the last value on the left to fill the equation down. Put your cursor on top of the black block on the bottom right corner of the cell. To put the same equation in each of the other cells, click on the cell where the equation is located. Step 4 - Press Enter after entering the equation. Step 3 - In cell B2 enter the equation Excel will use to calculate Y. Step 2 - Enter seven values for x in column A. Step 1 - Open excel, type x in cell A1 and type y in cell B1. Excel will be used to create the values from the equation, will then be used to display a scatter plot of the data, and then will be used to find the best fit for the given data. The equation which will be used in this example is y=3x-2. This tutorial will use a linear equation to create a table of values for Y when given a set of x values. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |