The y-axis on the graph is also known as ordinate. The x-axis on the graph is also known as abscissa. The image below represents the coordinate plane with both axes. The point where the x and y-axis intersect is known as the origin and is used as the reference point for the plane. The horizontal axis is represented by the x-axis and the vertical axis is represented by the y-axis. x-axis and the y-axis that form a coordinate plane for a graph. Excel uses a comma by default, OpenOffice a semi-colon.A x and y graph can be defined by the two axes i.e. To display the slope and intercept in OpenOffice for the above data, use the following functions: The graph will display the best fit line, but not the function.Choose the linear regression, click on OK.Choose create (the various titles can be filled in as appropriate).The first variant works best in this course.Drag to indicate where the graph should be located and how big the graph should be.Select the data and click on the chart wizard.For directions on using version 2.3, refer to the notes on version 2.4. Starting with version 2.3, the chart wizard does not wait for the user to use the mouse to drag the chart location. In version 2.3 the chart wizard was altered. The following directions apply to Calc versions 2.0, 2.1, and 2.2. Distribution of 3.0 and 3.1 on Windows continue to use a semi-colon.Įxcel 2007 uses different screens to obtain a linear regression.Ĭreating an xy scattergraph in Calc 2.0 3.0 and 3.1 on Ubuntu 9.04 and 9.10 respectively use a comma. Excel uses a comma by default, OpenOffice 2.0 a semi-colon. To obtain the slope and intercept in Excel for the above data, use the following functions: Select both Display equation on chart and Display R-Squared value on chart (the image shows only the first item being selected.Choose a linear regression and then click on the Options tab.Click on a point on the chart to highlight the data points:.Select the data and click on the chart wizard button:.Creating an xy scattergraph in Microsoft Excel and Calc 2.0 Creating XY Scattergraphs with SpreadsheetsĬreating an xy scattergraph in Microsoft ExcelĬreating an xy scattergraph in Calc 2.0 Creating an xy scattergraph in Microsoft Excel

How to plot a graph in excel x vs y