How to plot a titration curve on excel

Written by matthew weeks
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to plot a titration curve on excel
Titration curves in Excel are best represented with scatter diagrams. (Ryan McVay/Photodisc/Getty Images)

In chemistry terms, a titration curve tracks the pH level of a solution as a substance with a known concentration and volume is added to it. This type of curve consists of a shallow slope ascending into a very steep rise and then levelling off into another shallow slope. As such, a standard linear, polynomial or curved regression trend line the likes of which Excel's Chart Wizard produces would not represent the curve accurately. Fortunately, you have another option.

Skill level:
Moderately Easy

Other People Are Reading


  1. 1

    Open a new worksheet in Excel, and create two column headings with the titles "Titrant Amount" and "pH Level." Fill out the two columns with the data you have measured.

  2. 2

    Highlight your entire data set, including your column headings, by clicking and dragging your mouse across it.

  3. 3

    Click the "Chart Wizard" button in the toolbar. Click the XY (Scatter) chart type to select it, then select a "Scatter with data points connected by smoothed Lines" chart. Click "OK"; Excel will generate the chart with the smoothed titration curve on top of the data series.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.