Creating publication-quality forest plots in Excel | Spreadsheet Synthesis

Подписаться 3,2 тыс.

Просмотров 35 тыс.

50% 1

A forest plot is a type of scientific plot that displays effect sizes and their 95% confidence intervals in a vertical stack to emphasize variability in study outcomes as well as pooled effects (grand means) across studies estimated using fixed effect or random-effects meta-analysis.
00:00:00 Here I show you how to generate a forest plot using Microsoft Excel:
00:02:30 setting up and organizing spreadsheet
00:11:43 manipulating scatter plot to display a forest plot
00:28:04 cleaning up the plot and improving clarity of information
00:33:47 conclusions and brief history of forest plots in medicine and other scientific disciplines that use meta-analysis
#excel #ForestPlot #meta-analysis #LajeunesseLab
cite this video (follow figshare link for dataset):
Lajeunesse, M.J. (2021): Creating publication-quality forest plots in Microsoft Excel. figshare. Online resource. DOI: 10.6084/m9.figshare.14161310
playlist of other Excel videos for research synthesis:
• Spreadsheet Synthesis ...

Наука

Опубликовано:

6 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 70

@LajeunesseLab 3 года назад

Hi all, thanks for watching! I have more tutorials using Excel for meta-analysis and systematic review practices, the full list is found here: ru-vid.com/group/PLMDcoG6cxhI0EaLoG9jG7fmf22YIUjD-o

@YvesAustin 8 месяцев назад

Wow! Incredible use of x,y scatter plot. Transforming what would otherwise be the vertical axes as data points and using data labels is brilliant.

@Scandinasican2 3 года назад

This was SO helpful! I didn't have time to learn R for the paper I'm working on, and this is EXACTLY what I needed. Thank you!

@LajeunesseLab 2 года назад

You are so welcome!

@sunsetglowlove 2 года назад

This was the first time I've ever had to create a forest plot and this video was extremely helpful! THE BEST!

@LajeunesseLab 2 года назад

Awesome! Thank you!

@Moonstonn 2 года назад

Once again sir, I doff my hat to you. This video has been a life saver! My only error was looking elsewhere before remembering to check your channel. You're right, this process is tedious but until I get R, or any other software, these Excel tutorials you upload are my lifeline to doing meta-analysis. Thank you for spending half an hour for my sake Dr. Marc 😅

@ednamarinadesouza4458 2 года назад

Thank tou very much, amazing explanation!

@oktiratna2985 2 года назад

Thank you for providing the video. It really helpful. In my experience, to do practice while watching video, it much easier to learn using two screens, one for practices, another for watching the video. Then, for different excel version, it may have different location to find the function, a little bit stressful in the beginning. Also, need a little bit manually adjustment for y axis (can not use 1, 2, 3, etc) and perform risk ratio value (manually move to the right).

@0000000Fritz Год назад

Thank you so much for this video! Finally a good source for making a forest plot on Excel. It helped me a lot. Greetings from Germany!

@LajeunesseLab Год назад

You're very welcome!

@audaxious 2 года назад

Great video and super useful! Thank you so much!

@LajeunesseLab 2 года назад

Glad you enjoyed it!

@o45727 7 месяцев назад

didn't want to use R so this was massively helpful!!

@LajeunesseLab 7 месяцев назад

haha, this is great!

@RhushiZiradkar Год назад

This video and the rest of the series have been fantastic and so helpful. Thank you! Your passion for this topic is clearly evident as well, which makes it that much better. Is there a way to make funnel plots for publication bias through Excel? Not sure if you made a video on this already, but I didn't see one. Thanks again for uploading these!

@ishaelken3120 2 года назад

This is a great video. Very helpful

@LajeunesseLab 2 года назад

Glad it was helpful!

@Goole1947 3 года назад

Also you're a god you saved my dissertation

@LajeunesseLab 2 года назад

Thank you so much!

@amirraza8486 3 года назад

Super I appreciate your teaching and skill

@LajeunesseLab 3 года назад

Thanks Amir!

@danielgallegos3963 3 года назад

Thank you so much! You saved me!!

@LajeunesseLab 2 года назад

You're welcome!

@anasalharbi8008 3 года назад

great demonestration. Thanks a lot for your time

@LajeunesseLab 2 года назад

Glad it was helpful!

@Nawazash 3 года назад

great description sir...very helpful

@LajeunesseLab 2 года назад

Thanks!

@lalnoumas2577 3 года назад

you helped me do well in my report. thanks

@LajeunesseLab 3 года назад

Glad I could help!!

@roobadinthehouse 2 года назад

Thank you so much !!!

@vagabundo8450 2 года назад

Great tutorial, if you want to use excel

3 года назад

This was soo good. I like how excel can do a lot of things (if we know how to use it). Thanks for the video

@LajeunesseLab 2 года назад

Glad you enjoyed it!

@top10trendingitems88 2 года назад

Thx for your precious efforts. Please try to share the excel that you used as an attachment so we can use it as a template.

@jeevanthapa6810 3 года назад

wonderful.. thank you a lot..

@LajeunesseLab 2 года назад

Thanks for watching!

@vishnueashwar Год назад

Not all heroes wear capes

@posamsaso 3 года назад

Really helpful! I'm a basically R user, but the OR plot i made with packages was not satisfactory. Your video enables me to make a more 'customized' plot for me. thx a lot!🍺

@LajeunesseLab 3 года назад

Glad I could help!

@wl9318 Год назад

May I ask where did you get the 7.39? Thank you so much

@belkenfack1177 3 года назад

Thank you so much

@LajeunesseLab 3 года назад

Glad it was useful!

@lalabengals Год назад

overall great vid but why is the error bar for Comstock & webster (6.53) going all the way to 7.39?

@suprateekat5338 3 года назад

Thanks for the video, that is very useful. RevMan software is also a useful toolkit to use and straightforward to use.

@LajeunesseLab 3 года назад

Great tip!

@LA-qd9io 3 года назад

Thanks for the great video - would be lost without it! I have one more questions: can negative effect sizes also be included in a meta-analysis? Bc. when i want to use the formula for the SE = ES/SQRT(ES*N) you cant take the SQRT of a negative effect...

@LajeunesseLab 3 года назад

Yes you need to include negative effect sizes -- since sampling error alone can create study outcomes with positive, null, or negative effects. Calculating the SE of effect sizes is not conventional, SD and 95%CI are the standard presentation approach. I am not familiar with the equation you are using for meta-analysis.

@suleimanidrisahmad9453 2 года назад

Thanks for this video. This is amazing. Is the forest plot specific to meta-analysis? Can we use it for observational studies?

@LajeunesseLab 2 года назад

Yes you can use it, as long as the outcome has confidence intervals

@michellehweephengtan3101 Год назад

@@LajeunesseLab Thanks so much for this ! Can I create a forest plot just to view a range of numbers for quality of life values reported in different studies: example , for diabetes related complications ? Not meant to do a meta analyses but just narrative synthesis ?

@k9gff 2 года назад

Any suggestions how you can change the size of square boxes (ie effect sizes), in the R plot you have shown the boxes are different sizes but in the final excel file they are all the same size.

@LajeunesseLab 2 года назад

Excel is not friendly with boxes of different shapes or sizes, but it is possible -- you'll need to begin with a bubble plot rather than a scatter plot

@tracyquetzal9477 2 года назад

Hi I would like to know how to make a Forest plot of the log of the odds ratio and its 95% confidence interval for comparison of categorical predictor variables in logistic regression? I have multiple variables I need to compare. I would like to have 6 forest plots combined together. How can I do this in excel?

@user-se6yx8zr5g 2 года назад

Awesome tutorial and great teaching! Q: how would you address the weights issue? both the calculation (haven't seen you talk about that in any of the other videos) and in the plot?

@LajeunesseLab 2 года назад

For the weights, excel is still not friendly to customize in this way and easily have different sizes. But excel gets updated all the time, so maybe in the near future this issue will be address :-)

@Selvax94 Месяц назад

Hi and thank you very much for the amazing work. QUESTION: why in hell my title crossbars don't show the negative part of the bar? I've tried everything, including "show both sides" obv... I feel like my excel is just bugged sometimes, like when I select a series of values or bars in the graph not all of them appear selected (light blue dots around them) but the actually modify if I change values 😅. I'm lost guys😞

@naziyatarannum1037 Год назад

How to calculate risk ratio in excel?

@ChynaTropic19 3 года назад

What does the RE and FE Models mean and how can I compute them?

@LajeunesseLab 3 года назад

These are estimated using meta-analysis techniques, I have a video on how to calculate these, if you wish to use excel: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-i66Lf2a_Pa8.html

@morgannickell7447 2 года назад

I am making a forest plot with 3 subgroups. How do I calculate the point estimates for each subgroup on excel? (i.e. how do I calculate the diamond's location for each subgroup?)

@LajeunesseLab 2 года назад

This is a more challenging task, and perhaps too difficult to discuss here in the comments -- but maybe I can do another video to help with these special cases :-)

@Goole1947 3 года назад

Sir I'm trying to learn R but I have no idea how to make a forest plot on it. I can make l'abbe plot but that's it. Also can you use the odds ratio for this?

@LajeunesseLab 3 года назад

yes, any effect size (e.g., odds ratio, hedges' d, correlations) can be used, this video focuses on log scale effects, but you can ignore that section for regular effect sizes

@Goole1947 3 года назад

Is it possible to make a forest plot video for R? Like with event rates and stuff extracting from excel? Just can't find any decent tutorial online.

@kikidebby1149 Год назад

Hello, please I would like to ask you some questions. How can I contact you?

@cavessavia5378 3 года назад

How to make diamond shape, sir? I made everything except this part

@LajeunesseLab 3 года назад

unfortunately mimicking the multi-sized diamonds is not possible unless you format the marker with your own built-in marker-type or size

@ChynaTropic19 3 года назад

How did you get the confidence intervals?

@LajeunesseLab 3 года назад

Confidence Intervals are calculated from the standard deviation of each effect size, the the confidence of pooled means are estimated using meta-analysis