When facing chemical equilibrium problems of the type

it is often useful to construct logarithmic concentration versus pH diagrams to illustrate how the concentrations of the ions are dependant of the pH-value.

The theory behind the diagram is not too complicated and the construction is straightforward. However, generating nice looking diagrams can be time-consuming and tedious and therefore I wanted to share my excel template for generating dibasic log concentration – pH diagrams.

This template is intended for dibasic systems and can ideally be used for school assignments or teaching. The excel template will generate a diagram looking like the below example:

Any feedback is appreciated and can be left via the comment function below.

Popularity: 4% [?]