How to Put Two Sets of Data on One Graph in Excel. One of the advantages of using Excel as your spreadsheet application is that you can display a simple piece of information just as effectively as ...

Graph Two Sets of Data Simultaneously Launch Excel and start a new, blank worksheet. Type in the X axis data in the leftmost column of your worksheet.

Scatter diagrams are used to explore patterns between two sets of data. The table shows the results of eight students' maths and science marks in an assessment. Construct a scatter graph that ...