How To Create A Forest Plot In Excel (Odds Ratios)
Тәжірибелік нұсқаулар және стиль
In this tutorial, I’m going to show you how to create a forest plot by using Microsoft Excel. I will show you how to create the forest plot by using odds ratio data with 95% confidence interval whiskers.
ONLINE GUIDE
toptipbio.com/forest-plot-mic...
HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Screen recorder & editor techsmith.z6rjha.net/c/198849...
KZread SEO www.tubebuddy.com/SHTeach
Software (Microsoft Excel 365 ProPlus)
FOLLOW US
Website toptipbio.com/
Facebook / toptipbio
Twitter / toptipbio
AFFILIATE DISCLAIMER
Some of the above links are affiliate links, meaning I will earn a commission if a sale is made after clicking on the link
Пікірлер: 84
ONLINE GUIDE toptipbio.com/forest-plot-microsoft-excel/
@nanotechno1
Жыл бұрын
hi, I have 95% confidence intervals for positive B coefficients which have negative values and positive values, but the negative values are not appearing at all on excel on the forest plot I created. Do you have any idea how to correct this?
Such an informative video......I can't imagine making forest plot without this video
Thank you for this! Here's another way to add the vertical axis line - right click the vertical axis (labels)>format axis (fill and line), and change the line to solid black. Then right click on the horizontal axis>format axis, and under 'vertical axis crosses' select 'axis value', and input '1'. You'll also need to make sure 'label position' (for the y axis) is set to 'low', as mentioned.
To add a solid line into the graph without manually drawing and lining it up. Create a new column and put 1 as the value for each line. Select Data -> Add and then for x axis select the row of 1s, for the y axis select the position column. Then change chart type to scatter with line. You can then remove the marker and change the line to solid black. Thanks a lot for the video!
@StevenBradburn
2 жыл бұрын
Excellent! Thanks for sharing George!
This was amazing! Something i would have never figured out how to do on my own. Thank you so much!!!
Loved this tutorial, I used it step by step to make the plot
Thanks so much, Steven for this tutorial. It was straightforward to follow and do the graph with your instructions. Congrats!
This is amazing, thank you so much! You have helped a poor soul's thesis!
Thank you for this - I watch it probably every 4 months when I have to do these!
Thanks! OMG I wish you all the happiness in the world!
Great tutorial, followed with ease!
Thank you. You solved my problems. I learn many thing from this video. Long live brother.
Thank you. That was a great tutorial and I learned a lot. Great stuff. Looking forward to other tutorials from you.
I was worried that I wouldn’t be able to do it. Someone helped me before, but they forgot to do the line at the one marker. You made it easy.❤
Thank you! Great tutorial..Really helped!
This was so helpful! Thank you so much!
Thank you! SAVED me on my group on our school project :)
Thank you for making this video! Very helpful👍
Great tutorial, extremely useful! Kudos!
Most grateful to you! This is so helpful : )
Thank you very much for this video!
This was amazing. Thank you!
Beneficial video. Made my task easier. Thanks a ton!!
Thank you so much! I managed to make the graph.😉
Very useful, thank you!
Great tutorial, thanks. Unfortunately, scatterplot points are not aligned with the bars. Do you know what is the problem ?
@tomphillips88
8 ай бұрын
For me, it was formatting the right y axis so that minimum value was 0 and maximum value was the nearest whole number above your highest position (i.e. top position of 19.5, make maximum 20)
@danielthomson9178
4 ай бұрын
@@tomphillips88 Yep that fixed it, thank you!
This was very simple video, nicely explained
Really useful imformation. Thank you very much.
Nice tutorial. thanks, learnt easily
this is great tutorial and it's worked for me,,,by the way, can we calculate pooled OR in excel with only OR (95%CI) data from several studies?
Thanks for this! It's helpful. Can you also show how to do this in R?
Hi there. Great video!!! I have 14 variables, unfortunately, the lines are squished so that the top label doesn't have a line beside it. How can I fix this. Do you know? Also, can I add labels between study one etc. I have variables such as age, clinic etc. So I would love to add variable titles. thanks for the vid!
You saved my day!
wow. someone needs to buy you a beer friend! lifesaver
Really nice tutorial. Thanks! If i use Hazard ratios however can i Use the same forest plot? Thanks in advance
wow, this was very helpful =)
THIS SAVED ME!
Really impressive, amazin!
Excellent. Superb.
Thank you!!!!!!!!!
Thanks!
Very useful, just want to know if the difference between upper and lower 95% is very small, the plot hardly shows. How do u enlarge the plot size? I hope i am clear in my question.
Thank you for this, you have just saved me a panic attack lol
Thank you
Gracias!!!!!
Really awsm
Grazie
Can you calculate 95%CI if I know the Standard Deviation and add these in excel?
Thank you for this. Very straightforward, very clear, and very helpful. A tad fast when talking. Need to slow down.
@StevenBradburn
2 жыл бұрын
Thanks for the feedback Blaise. I will take that on board for the future :)
Really great tutorial! Question: When I add a new series and change it to "scatterplot," all of the scatterplot points appear off-centered compared to the bars (see 3:40). Have you encountered this problem before?
@StevenBradburn
3 жыл бұрын
Hi Aidan When selecting the position data (with effect size), did you highlight the cells in the same order as you did when creating the bar chart? If not, then this may result in the points not aligning with the bars. Hope that helps, Steven
@PhuongPham-gi2fl
3 жыл бұрын
@@StevenBradburn Hi Steven, thank you for the great video! I also have the same problem as Aidan with all the scatterplot points appearing off center compared to the bars. The order is correct, only the points are not well aligned with the name. I tried to change the value of the position to move the points and it seemed work until the last point (appear on the top the graph), no matter how big the value I entered it could not reach the position of the top bar..
@user-jz8qc2br3b
2 жыл бұрын
I realized what the bug is. in the video we have 8 studies. and the step is 0.5. I have 4 studies, and if the step is 0.5, then the points are not in the middle. You need to have a step of 0.625 for 4 studies. Moreover, the first point will have half a step - 0.3125. then the numbers 0.3125, 0.935, 1.560, 2.185 are obtained. I think there is a step for each number of studies. I picked up the first point myself. then I already understood how to build others. !!! and here's another thing: when I did 4 studies, and deleted one, the dots remained in the middle. thus, I think that you need to do 8 studies first, and then delete the extra lines and another thing: if one indicator is too big (I had 770), and the others are small (2-10), then you need to choose a logarithmic scale in the legend.
Does this generate an adjusted or unadjusted 95 % CI?
Thank you so much!! Very helpful! I have two questions: 1. How do I make the caps longer (at the end of the error bars)? 2. For me, the studies are too spaced out. How do I get them to be vertically closer together? I tried decreasing the interval of the numbers in the Position column (e.g., 0.25, 0.75, 1.25.... instead of 0.5, 1.5, 2.5...) and that did not work.
@tomphillips88
8 ай бұрын
For me, it was formatting the right y axis so that minimum value was 0 and maximum value was the nearest whole number above your highest position (i.e. top position of 19.5, make maximum 20)
How can I add a label to the OR on the forest plot?
It would be helpful to show how to do this on the log scale because the OR is the log odds
@enejimmie825
Жыл бұрын
Currently looking for any resource to get this done.
@naomi89able
10 ай бұрын
Hit the x axis, format axis, scroll down and click logarithmic scale
Good step-by-step. But.. It doesn't work well. The OR's don't align and sometimes the CI's don't actually correspond to what it's supposed to. I spent over 8 hours working on this and I am confident I did it right. I think having too many studies is the issue perhaps?
The line added at x=1 disappears upon saving the chart as a picture.
do you have excel file to download?
better than doing it in R or SAS or Stata
Hi, how do you manage that numbers like "1.9" will not automatically change to "January 9th"?
@nathan-zuckerman
Жыл бұрын
I know that move with the apostroph, but then the data will not show in the bar chart anymore
why is this working for everyone but me
The dots are not lining up
How to interpret results?
@StevenBradburn
Жыл бұрын
Have a look at this vi kzread.info/dash/bejne/gqynksmlY8u4e6g.html 👍
Is it possible to have too many “studies”? My scatter points aren’t aligning with my bars. I have 14 studies.
@mahmoudel-yousef4151
Жыл бұрын
Hi Noah, I had the same issue with 12 studies, I fixed it by changing the secondary y-axis maximum to 12. Would probably work for you if you updated the y-axis maximum to 14.
@hyewon1161
Ай бұрын
@@mahmoudel-yousef4151 THANK YOU SO MUCH
why a 10 min video for something that can be explained in 2 mins?