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

Instructions

  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

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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