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.