Two options use smooth lines with or without markers and work best for plotting functions, and two use straight lines with or without markers and are best for data composed of separate values like the attendance.
Community Q A Search Add New Question Question How do I name the y and X axis in the graph?
Your entire data series should be highlighted.
Creating a Scatter Plot, open a new, excel file and, in a fresh worksheet, enter your " x " data as a series of numbers going downwards in a single column.
Once you decide on a template, clicking it will create your line graph in the middle of the Excel window.
3 Resize the graph.Sciencing Cross; Dont Go!This will open the, insert toolbar below the green ribbon.4 Change the graph's title.Continuing the example, list Mark's attendance in cell B2 and his test score in B3, cadeau voor hem 18 jaar and record Mary's attendance in C2 and her test score in C3, and.In the example of students' sleep, the school grades would be the y data.
A banner of options will open along the top of the window.
For example, plot the longitudes of different locations in the first column so it is plotted onto the x -axis and their latitudes in the second column for the y-axis, including negative values as needed.