Very nice. Well explained. Thank you for sharing ;)
@enriquevalentin5245 Жыл бұрын
I'm so thankful!!!!! :))))
@traviswhitfill5092 жыл бұрын
This was SO helpful. Thank you so much!
@imenemansouri43252 жыл бұрын
Thank you very much for this video super helpful. I would lover to follow you on twitter if you have one ;)
@theflamekid2 жыл бұрын
Hello, I have some trouble, I have 28 factors and while the bottem labels of the factors are in line with the graphs (the dot and error bar) the graphs are everytime a bit to higher when you go one variable up so the first labels are totally out of place. Edit: the bars are in place but the "dot and line" not in line with the bars
@giuliadiicorsica Жыл бұрын
I think I had the same problem you did, and I realized I had to readjust the secondary vertical axis so that the maximum number was 1 above our highest count while the minimum was 0, and then the issue was fixed. Gave me a grey hair though.
@HuyNguyen-rv9ge3 жыл бұрын
Erica, can you let me know where I should click to get countdown? as you did so fast and can not see it.
@shuktatube53333 жыл бұрын
An excellent explanation for me. Thank you!
@haihuang75293 жыл бұрын
thank you very much
@Ftrtts.3 жыл бұрын
Thank you so much!! I really didn't know how I was going to graph my odds ratio so this really helped!
@bjfiero473 жыл бұрын
Excellent tutorial. In the end, I would like to add that if your CI's are very wide using the format axis option (for the axis with numbers) and choose the option "logarithmic scale base 10" with axis bounds set to auto. Then format axis for the axis with factors at set label position to "low".
@VictorAntares3 жыл бұрын
Thank you. My committee loved the plot. And I guess the reviewers did too.
@mamadouadamasow94773 жыл бұрын
Very good, thanks
@suprateekat53383 жыл бұрын
Thank you so much for this video!! It is very clear with every step and so helpful, saved me so much time from having to search endlessly for other videos Unfortunately this does not work with 10 or more factors.
@chukwuemekaogbu8037 Жыл бұрын
Yes. It does not for 8 factors too. Do you know any video where i can watch how to do this?
@pragalathannaidoo78453 жыл бұрын
Thank You. Explained well.
@majoramirez77673 жыл бұрын
You are amazing!!! thanks!
@osupermono3 жыл бұрын
Hi Erica, you don't know how many times I said "I love you"
@katiebeckerwa3 жыл бұрын
THANK YOU THANK YOU THANK YOU!!!!
@painless2633 жыл бұрын
wow. this was very helpful and easy to follow. My forrest plot looks great. Thank you!
@yongwoon963 жыл бұрын
한국인 이신가여??
@abbyscurfield20353 жыл бұрын
Hi Erica, thank you so much for this helpful video. I'm having an issue with my datapoint/label alignment, though. First of all, I'm seeing no tick marks at all on my Y axis, and second, when I go to change the "odds" data to scatter, it moves the datapoints further above the axis labels, and "positioning on tick marks" doesn't change it. Any advice for this issue?
@petraschultz3843 жыл бұрын
This was super helpful. Anyone know how to show two sets of data in the same plot area? For instance outcomes for two different groups, for instance different doses of medications. I'm looking to show OR for complications associated with two dose levels of same medication.
@olusegunadewaleadeyemi24993 жыл бұрын
Thank you Erica, you are a life saver
@fazeelzubair27873 жыл бұрын
how to draw diamond estimate?
@esawibowo57113 жыл бұрын
It turns out that there is a problem when using 12 variables ... I found a solution by adding 1 more empty column above it (in the explanation only 1 empty column above) ... hope it helps
@ricardomorato28753 жыл бұрын
Thank you! You have just helped me a lot! Made some forest plots for my master thesis. Thankssss.
@nunodenoronha3 жыл бұрын
Hey, Ricardo! Não estou a conseguir fazer. Dá-me erro coma fórmula mesmo mudando as células - (ROWS($A$4:$A$11)-ROW()+ROW($A$4:$A$11)) A ti não te deu erro?
@ricardomorato28753 жыл бұрын
@@nunodenoronha se estiver usando o Excel em português, substitua o ROW/ ROWS por LIN/LINS. Eu também não consegui nessa parte, até perceber que era o idioma
@nunodenoronha3 жыл бұрын
@@ricardomorato2875 Muito obrigado pela sua ajuda! Um abraço
@nunodenoronha3 жыл бұрын
@@ricardomorato2875 Só mais uma dúvida: Depois de você escrever LIN/LINS e alterar o número das células, a série de números que lhe apareceu estava correta? A minha série de números começa em 4 e acaba em 7, não em 1.
@ricardomorato28753 жыл бұрын
@@nunodenoronha se vc começou sua série de fatores na linha 4, é só alterar o segundo valor para o número da última linha que contém fator. Pelo que vc falou, na sua tabela seria de 4 a 7, enquanto no vídeo foi de 4 a 11
@youngmoneymahini3 жыл бұрын
Joe Rogan
@diegoramonfaur78373 жыл бұрын
Thank you, this was extremely helpful. Can you individually change the color of individual circles? EVery time I try to chanche the color every circle changes color as well.
@maribres3 жыл бұрын
Thank you very much for this help! Wonderful video!
@toyvousamaki4 жыл бұрын
Very helpful thank you
@jenniferangel98034 жыл бұрын
Thank you so much Mam :)
@statisticstime47344 жыл бұрын
Excellent!
@markeid114 жыл бұрын
when I try to add in the odds ratios, the values seem to add in an a different y axis- and I cannot get the values to match with the original bar countdown values. I am using excel 2016 on a Mac.. Any suggestions?
@daviskibo13 жыл бұрын
Im having the same problem
@robertridde69143 жыл бұрын
For OR polts , you need to select your OR values column for X-axis data series, and the Countdown column for Y-axis data series. I'm using excel 2016
@daviskibo13 жыл бұрын
@@robertridde6914 Thanks for the reply. That what i did, reslts: same problem
@flash2hridya3 жыл бұрын
I have the same issue, odds ratio scatter dots are not aligning with the bars
@nycollassilva3558 Жыл бұрын
Gwml1jqgik
@anthonybavry26424 жыл бұрын
My countdown column counts up instead of down. Also, when I try to change the red bar to a scatter plot, my figure falls apart.
@andreib.85654 жыл бұрын
i have the same problem with changing the red bar to a scatter plot. Did you solve the problem?
@sherinhanem7 ай бұрын
The same here
@tigerlitam94224 жыл бұрын
Dang. 3 and a half years later and still saving people like me at work haha. Thank you Erica
@boudebabaabdelghafour30004 жыл бұрын
very helpful thank you so much <3
@kristianj.salasespinoza35824 жыл бұрын
Thanks Erica, I was wondering how to show the p values in the graph.
@drlalatendumoharana4 жыл бұрын
Thank you ma'am for the video,, it was very helpful. ma'am I am unable to align the x axis lebels to their respective odds ratios. kindly help
@leahdodds92424 жыл бұрын
The error bars are not adjusting accurately using excel 16. Is there a way to fix this? It seems like they don't adjust even after specifying the value
@gm-xx4fh4 жыл бұрын
most comprehensive, clear and instructional vid I have ever come across on youtube...thx
@aakashrahman76524 жыл бұрын
Excellent work. Thanks
@mayraysann74804 жыл бұрын
Just what I needed! Great tutorial. Only note I would add is depending on the version of Excel you have you may need to adjust your y-axis range if the scatterplot points don't align with your countdown/factor labels :)
@anjalyjohn56004 жыл бұрын
Hi ! How do I do this ?
@pauldahlke56184 жыл бұрын
@@anjalyjohn5600 Before you delete the right hand axis (for the scatter plot) change its max bound to one higher than your amount of factors.
@meenamaharjan38823 жыл бұрын
@@pauldahlke5618 Thanks to you! Finally it worked.
@ericengels21164 жыл бұрын
This video is very helpful. I just wish it was not so difficult to make these graphs in Excel. Really appreciate your time and effort in explaining this clearly.
@marias41374 жыл бұрын
Hi! The formula =(ROWS($A$4:$A$11)-ROW()+ROW($A$4:$A$11)) gives me #NAME error, could anybody help me? Thank you so much
@Leon1Das-MJPZ4 жыл бұрын
I had the same problem. In the end the problem for me was that the language of Excel was in Dutch in my case. So if your excel program is in another language you should change the term ROWS into the language that your Excel is set up in.
@mariasanz86434 жыл бұрын
@@Leon1Das-MJPZ Thank you so much for your help!
@Leon1Das-MJPZ4 жыл бұрын
@@mariasanz8643 Did that fix it?
@mariasanz86434 жыл бұрын
@@Leon1Das-MJPZ yes it did! thanks so much
@fezalikhan4 жыл бұрын
One question professor, from where you got the initial values, I mean lower, upper, and Odds?
@Leon1Das-MJPZ4 жыл бұрын
That would be data extracted from literature or from your own investigations.
@alexanderbichev68974 жыл бұрын
Does not work under the Office'2013.
@brianac72734 жыл бұрын
Anyone know how to get a bold vertical line on the odds ratio of 1 so that the reference is well seen?
@loriegabidel4 жыл бұрын
The only way I know how to do it is to manually add a line using the shapes tool.