GENERATING A PLOT FROM MULTIPLE DATA SETS $($Exercise $2)$

At the bottom, click on $"+"$ to add a new worksheet. Change the Label on this worksheet from "Sheet $1"$

to "Multiple Data Sets".

To generate a graph from multiple datasets, we need to first create the multiple data sets. In this

example, we will create these data sets by using the same line graph problem with different slopes.

Consider $m=0\mathrm{.}1,0\mathrm{.}2,0\mathrm{.}3,0\mathrm{.}4$ and $0\mathrm{.}5.$ Manually enter the data in rows $1-3$ and column A$.$ Now,

recreate the layout as shown in Figure $2\mathrm{.}4$ and calculate the data for the other $5$ columns using the

formula $y=mx+c.$ Enter the calculation in cell B$4$ using cell references. Then copy to the remaining

cells. Note that you will need to use an absolute cell reference to access the value in cell B$2.$

Figure $2\mathrm{.}4$ Setting up the spreadsheet for multiple graphs

To generate multiple graphs from scratch, we just have to select all the data A$3$:F$3$ to A$14$:F$14,$ click on

the "Insert" ribbon and choose "scatter" and follow the instruction for plotting a graph. The graph

displayed should be similar to Figure $2\mathrm{.}5.$

To add a line to an existing data set, we can copy the new data and paste it on the graph. We could also

click on the graph and this would highlight the cells on the spreadsheet that are included in the graph.

You can then add additional data to an existing graph by extending the selected cells boundary $($blue

boundary shown below$)$ to include the adjacent columns as shown in Figure $2\mathrm{.}6.$ Finally, we could right

click on the chart and click on the "Select Data" option and click on "Add" to add a new series.

Figure $2\mathrm{.}6$ Adding data to an existing graph.