Open In App

How to Create a Forest Plot in Excel?

Improve
Improve
Like Article
Like
Save
Share
Report

Forest plots are an excellent way to convey a multitude of information in a single picture. Forest plots have become a recognized and well-understood technique of displaying several estimates concurrently, whether used to demonstrate various outcomes in a single research or the cumulative knowledge of an entire subject. This article investigates advanced uses of the forest plot with the goal of demonstrating Excel’s versatility in producing both basic and sophisticated forest plots. Forest plots are widely used to display meta-analysis findings. Unfortunately, no conventional forest plot graph option is available in Excel. In a meta-analysis, a forest plot is used to show the findings of many research in one figure.

Forest-plot

 

The x-axis represents the value of the interest in the research (often an odds ratio, effect size, or mean difference), while the y-axis represents the findings of each particular study. This style of display makes it easy to see the findings of several research at once.

Creating a Forest Plot in Excel

The following step-by-step example illustrates how to make a forest plot in Excel.

Step 1: Enter the Data: First, we’ll enter each study data in the following format.

Dataset

 

Step 2: Create a Clustered Bar Chart: Then, highlight the cells in the A2:B9 range. Click the Insert tab along the top ribbon, then the 2-D clustered bar option in the Charts section. 

Creating-clustered-bar-chart

 

The horizontal bar chart shown below will appear:

Horizontal-bar-chart

 

Step 3: Add scatterplot Points: After that, we’ll create a new series called Points, that we’ll use to add scatterplot points to the graph:

Adding-scatterplot-points

 

After then, right-click anywhere on the plot and choose Data.

Choosing-data

 

Step 4: Add Series: To add a new series, click Add in the select data source box that displays. 

Adding-series

 

Then, leave the Series Name field empty and click OK. This will result in the addition of a single bar to the plot: 

Adding-single-bar-to-plot

 

Step 5: Change Chart Type: Next, right-click the single orange bar and select Change Series Chart Type from the menu that appears. Change Series2 to a scatterplot in the new window that appears:

Changing-chart-type

 

When you click OK, the chart will show a single scatterplot point.

Single-scatterplot-point-shown

 

Step 6: Update Series: After that, right-click the single orange spot and choose Data

Choosing-data

 

Click Series2 and then Edit in the box that displays.

Editing-in-display-box

 

For the x-values, use the cell range containing Odds Ratio, and for the y-values, use the cell range containing Points. Then press the OK button. The scatterplot points listed below will be included in the plot.

Scatterplot-points-shown

 

Step 7: Remove the Bars: Then, right-click on any of the plot’s bars and change the fill color to No Fill.

Changing-fill-color-to-no-color

 

Then, on the right, double-click the y-axis and set the axis boundaries to a minimum of 0 and a maximum of 8.

Setting-axis-boundaries

 

 Then, on the right, click and erase the y-axis. The following plot will be left.

Erasing-y-axis

 

Step 8: Add Error Bars: For Graph Lower, take the Odds Ratio – Lower 95% CI.

Adding-error-bars

 

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

Adding-error-bars

 

Step 9: Add Error Bars: Then, in the upper right corner of the plot, click the little green + sign. Check the box next to Error Bars in the selection menu. Then, on any of the points, click on one of the vertical error bars and select delete to remove the vertical error bars.

Chart-elements

 

Then, under the selection next to Error Bars, select More Options. In the right-hand pane, enter the custom error bars to be used for the top and lower boundaries of the confidence intervals:

Custom-bar-errors

 

Step 10: Final Graph: As a result, As you can see, the chart resembles a forest plot:

Forest-plot

 


Last Updated : 05 Dec, 2022
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads