How to make a Scatter plot graph in Excel
Open a new Microsoft Excel Worksheet
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”.
In column 1, write the cumulative volume of NaOH (mL) starting from zero. Fill column 2, with
the pH values measured after each addition.