how do i use microsoft excel by graphing using an x and y coordinate?

Question

i have a project and it's graphing an x and y coordinate using microsoft excel, can you help me and provide the steps on how to graph it?

Answer 1

In column A, put values of x. I usually put something like -10, then make each cell below it be -9, -8, etc. up to perhaps 10. The values you pick will probably depend on your function.

In column B, put your y values. You can make this a formula based on column A. So if the equation was y = x^2, you would write =A1^2. Copy this formula down the rest of the column.

Now select those two columns and click the graph wizard. Pick an XY (Scatter) plot, and pick one with connecting lines. It should give you what the graph will look like.

Answer 2

Excel has a good help topic on this subject:

On the worksheet, arrange the data that you want to plot in a chart.

For an xy (scatter) or bubble chart, you can arrange the data in columns, so that x values are listed in the first column and corresponding y values and/or bubble size values are listed in adjacent columns.
Data in columns:X Y Bubble
1 2 3
4 5 6

Select the cells that contain the data that you want to use for the chart.

Tip If the cells that you want to select for the chart are not in a continuous range, select the first group of cells that contain the data that you want to include. Hold down CTRL, and then select any additional cell groups that you want to include. The nonadjacent selections must form a rectangle.

Click Chart Wizard on the Standard toolbar, or click Chart on the Insert menu.

Follow the instructions in the Chart Wizard.

Answer 3

Excel has a well aid subject in this area: On the worksheet, prepare the knowledge that you just desire to plan in a chart. For an xy (scatter) or bubble chart, you'll prepare the knowledge in columns, in order that x values are indexed within the first column and corresponding y values and/or bubble measurement values are indexed in adjoining columns. Data in columns:X Y Bubble one million two three four five 6 Select the cells that include the knowledge that you just desire to make use of for the chart. Tip If the cells that you just desire to prefer for the chart don't seem to be in a steady variety, prefer the primary organization of cells that include the knowledge that you just desire to incorporate. Hold down CTRL, after which prefer any extra telephone companies that you just desire to incorporate. The nonadjacent choices have got to type a rectangle. Click Chart Wizard at the Standard toolbar, or click on Chart at the Insert menu. Follow the directions within the Chart Wizard.

Answer 4

enter the data for the Y axis in column A, Enter the data for the X axis in column B. Click on grafts in the tool bar and follow the instructions, If you have a problem, email me the data and I will email back a graph.