It is sometimes helpful to graph more than one set of data on the same graph in order to compare them. Excel can help us do this.
The following tutorial explains how to graph more than one set of data in the same graph and connect the points with lines.
Graphing Two Lines Using a Scatter Plot with Connected Lines
Video Source (05:58 mins) | Transcript
Instructions
Make a table where the first column holds the values of the independent variable (usually the x-values). Put the corresponding y-values for each set of data in additional columns. Be sure to include labels for the columns.
- Highlight all the data as well as the table column labels that you want to plot.
- Go to the Insert Tab.
- Find the Charts Section.
- Select one of the Scatter Plot icons and select one that also connects the dots with a line.
- Edit ranges, axis titles, chart title, and anything else you want to adjust.
Need More Help?
- Study other Math Lessons in the Resource Center.
- Visit the Online Tutoring Resources in the Resource Center.
- Contact your Instructor.
- If you still need help, Schedule a Tutor.