Forest Plot – Excel

This tutorial will demonstrate how to create a Forest Plot in Excel.

Creating a Forest Plot in Excel

We’ll start with the below data. This dataset shows the Odds Ratio of ten different studies along with their lower and upper Confidence Intervals.

 

Create a Clustered Graph

1. Highlight the Study and Odds Ratio Columns
2. Select Insert
3. Click Bar Graphs
4. Select Horizontal Clustered Graph

 

Add Points

Add a points Column that starts at .5 and add 1 to each one until you get to the ending value

 

Add a Series

1. Right click on Graph
2. Click Select Data

 

3. Select Add Series

 

4. Leave everything blank and Click OK

 

Change Chart Type

1. Right click on Graph
2. Select Change Chart Type

 

3. Change Series2 to Scatter

 

Update Series

1. Click on Datapoint
2. Click Select Data

 

3. Click on Series2

4. Select Edit

 

 

5. Select Odds Ratio for X Values

6. Select Points for Y Values

7. Click on the Bar Series

8. Select Format

9. Change Shape Fill to No Fill

 

Add Error Bars

1. For the Graph Lower, take Odds Ratio – Lower 95% CI

 

2. For the Graph Upper, take Upper 95% CI – Odds Ratio

 

Add Error Bars

1. Select Scatterplot Series
2. Select + Sign in top right
3. Select arrow next to Arrow Bars
4. Click More Options

 

5. Select Custom

6. Click Specify Value

7. For Positive Error Values, Copy Graph Upper 95%

8. For Negative Error Value, Select Graph Lower 95%

 

9. Select the Vertical Line and delete to get rid of them so that we only see the horizontal error bars

 

10. Delete the axis on the right side

 

Final Graph

After making some optional adjustments, you can see the final graph below.