How to make a scatter plot graph.docx - How to make a...

This preview shows page 1 - 3 out of 3 pages.

How to make a Scatter plot graph in Excel 1) Open a new Microsoft Excel Worksheet 2) Name the columns you are going to need in row 1. In this case column 1 is going to be our independent variable “ NaOH (mL) ” and column 2 our dependent variable, or the results “pH”. 3) In column 1, write the cumulative volume of NaOH (mL) starting from zero. Fill column 2, with the pH values measured after each addition.
4) Select all the cells. 5) Go to the Insert tab, Charts section, select the scatter plot and the scatter with smooth lines and

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture