1. Select the data. To select the data for your graph click on cell A9, and then drag your cursor (it should be a thick cross) to cell B29.

2. Choose a chart type: In the Elements Gallery, click the Charts tab. (If you do not see the Elements Gallery, click on the Gallery button from the top menu.)
 

3. Select the group XY (Scatter). Within that group, choose Marked Scatter (the first option). A simple graph is created.

4. To add title and axis labels: First click on the chart to activate it. (Then click on the Toolbox button from the top menu if the Toolbox is not already open.) Select the Formatting Palette from the Toolbox. On the Formatting Palette, expand the Chart Options section. Under Titles, use the drop-down menu to select Chart Title or an axis. Below the drop-down menu, click Click here to add title, and then type a title. You can also remove the legend by looking under Other Options and using the drop-down menu to select None for Legend.

5. To add a trendline (including the equation and r-squared value), first click on the datapoints to activate them. Make sure you have activated all of them, not just one. From the drop-down box under the Chart menu at the top of the screen, select Add Trendline. A new dialogue box will appear. From the menu on the left side, select Options. Check the boxes for "Display equation on chart" and "Display R-squared value on chart."

Your graph should look like this: