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.

How get equation scatter chart excel