Question

Copy the data from the table below and paste it into the Sheets document.
Highlight all of the data and titles and create a Line Graph (Insert > Chart)
Retitle your graph to Average Number of Species Present on Rock
Customize your graph so that it looks nice - increase the font sizes of all text
Paste your graph onto this assignment, below the table. To do this, click on the graph so that the three dots in the top right corner appear → click the dots → click ‘copy graph’ → paste below. If it will not paste correctly, you can screenshot as an alternative.



Average Number of Species Present on Rock


With Pisaster
Without Pisaster
1963
17.0
18
1964
17.5
13
1965
17.8
7.5
1966
18.0
2.5
1967
18.2
2.5
1968
19
2.5
1969
19.5
2
1970
19.8
2
1971
19.9
1.5
1972
20.0
2.0
1973
20.1
2.5

Answer 1

I can’t access your Google Sheets to do this for you, but below is copy-ready data and step‑by‑step instructions so you can quickly paste it into Sheets, make the line chart, format it, and paste the chart into your assignment.

1) Copy this block and paste into cell A1 of your Google Sheet (it’s tab-separated so it should fill three columns):

Year With Pisaster Without Pisaster
1963 17.0 18
1964 17.5 13
1965 17.8 7.5
1966 18.0 2.5
1967 18.2 2.5
1968 19.0 2.5
1969 19.5 2
1970 19.8 2
1971 19.9 1.5
1972 20.0 2.0
1973 20.1 2.5

2) Make the line chart
- Highlight all cells you just pasted including the header row (A1:C12).
- Insert > Chart.
- In the Chart editor (right side) set Chart type to “Line chart” (or “Smooth line chart” if you prefer smoother curves).
- Make sure “Use row 1 as headers” and “Use column A as labels” are checked (this is usually automatic).

3) Title and axis labels
- In Chart editor → Customize → Chart & axis titles:
- Chart title: type exactly: Average Number of Species Present on Rock
- Horizontal axis title: Year
- Vertical axis title: Average number of species

4) Increase font sizes (suggested sizes; adjust to taste)
- Chart & axis titles:
- Chart title font size: 18–22
- Axis titles font size: 14–16
- Horizontal axis (Customize → Horizontal axis): Label font size: 12–14
- Vertical axis (Customize → Vertical axis): Label font size: 12–14
- Legend (Customize → Legend): Font size: 12–14; position: right or bottom as you prefer
- Series: optionally increase point size (Customize → Series → Point size 3–6) and choose colors for each series.

5) Improve axis range and gridlines (optional)
- Vertical axis (Customize → Vertical axis): set Min = 0 and Max = 22 to give space above the data.
- Gridlines & ticks: increase major gridline count if you want more reference lines.

6) Make it look nice
- Chart Style (Customize → Chart style): set background to white, border if desired, and make title bold.
- If you want markers at each data point, Customize → Series → Show point markers.

7) Paste the chart into your assignment (below the table)
- Click the chart in Sheets to select it. Click the three vertical dots in the top-right of the chart → Copy chart.
- Go to your assignment document (where you want it pasted). Click below the table and press Ctrl+V (Cmd+V on Mac).
- If Copy/Paste doesn’t work:
- Option A: Download an image of the chart: three dots → Download → PNG image. Then Insert → Image in your assignment and place it under the table.
- Option B: Take a screenshot of the chart and paste/insert the image under the table.

If you want, I can generate a preview image of the chart here if you’d like—just tell me which chart style (straight lines or smooth), preferred colors, and whether you want markers shown.