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?
8 Click a graph style.We use cookies to make wikiHow great.Click and drag the white space near the top of the line graph to move.Test score example above.For example, tracking your budget over the year would have the date in the left column and an expense in the right.
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.