How to Create a Bland-Altman Plot in Excel

A Bland-Altman plot is used to visualize the differences in measurements between two different instruments or two different measurement techniques.

It’s useful for determining how similar two instruments or techniques are at measuring the same construct.

This tutorial provides a step-by-step example of how to create a Bland-Altman plot in Excel.

Step 1: Create the Data

Suppose a biologist uses two different instruments (A and B) to measure the weight of the same set of 20 different frogs, in grams.

The weight of the frogs, as measured by each instrument, is shown below:

Step 2: Calculate the Difference in Measurements

Next, we’ll use the following formulas to calculate the average measurement and the difference in measurements for each frog:

We can then copy and paste this formula down to every cell in the two columns:

Step 3: Calculate the Average Difference & Confidence Interval

Next, we can use the following formulas to calculate the average difference between the two instruments along with the upper and lower 95% confidence interval limits for the average difference:

The average difference turns out to be 0.5 and the 95% confidence interval for the average difference is [-1.921, 2.921].

Step 4: Create the Bland-Altman Plot

To create the Bland-Altman plot, highlight the cells in the range C2:D21 as follows:

Along the top ribbon, click Insert and then click the first chart in the Insert Scatter (X, Y) or Bubble Chart group within the Charts group. The following scatterplot will automatically appear:

The x-axis shows the average measurement of the instruments and the y-axis shows the difference between the measurements from the two instruments.

To add a horizontal line that represents the average difference in measurements, we need to create a data series that shows the minimum and maximum values along the x-axis (0 and 30) along with values that show the average difference:

Next, right click on the chart and click Select Data. In the window that appears, click Add under the Legend Entries (Series) section:

In the new window that appears, fill in the following information:

Once you click OK, two orange dots will appear on the chart:

Right click on one of the orange dots and click Format Data Series…

In the window that appears on the right side of the screen, click Solid Line:

This will turn the two orange points into a solid orange line that represents the average difference between the two instruments:

Repeat this process for the upper and lower confidence interval lines.

Feel free to modify the line styles, axes names, and title of the chart to produce a Bland-Altman plot that looks aesthetically pleasing:

Bland-Altman plot in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *