- Видео 2
- Просмотров 244 196
Erica Lee
Добавлен 2 янв 2017
Microsoft Excel - Horizontal Bar Graph - X-Axis Labels with Text
Microsoft Excel - Horizontal Bar Graph - X-Axis Labels with Text
Просмотров: 11 648
Видео
Microsoft Excel - Forest Plots (Odds Ratios and Confidence Intervals)
Просмотров 233 тыс.7 лет назад
How to make forest plots using Microsoft Excel 2007. Thank you Jon Peltier for sharing your method. Countdown Column Equation: =(ROWS($A$4:$A$11)-ROW() ROW($A$4:$A$11))
Thank you for sharing a good tutorial
Thank You
Life saver, thank you!
How to interpret results?
Very nice. Well explained. Thank you for sharing ;)
I'm so thankful!!!!! :))))
This was SO helpful. Thank you so much!
Thank you very much for this video super helpful. I would lover to follow you on twitter if you have one ;)
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
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.
Erica, can you let me know where I should click to get countdown? as you did so fast and can not see it.
An excellent explanation for me. Thank you!
thank you very much
Thank you so much!! I really didn't know how I was going to graph my odds ratio so this really helped!
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".
Thank you. My committee loved the plot. And I guess the reviewers did too.
Very good, thanks
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.
Yes. It does not for 8 factors too. Do you know any video where i can watch how to do this?
Thank You. Explained well.
You are amazing!!! thanks!
Hi Erica, you don't know how many times I said "I love you"
THANK YOU THANK YOU THANK YOU!!!!
wow. this was very helpful and easy to follow. My forrest plot looks great. Thank you!
한국인 이신가여??
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?
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.
Thank you Erica, you are a life saver
how to draw diamond estimate?
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
Thank you! You have just helped me a lot! Made some forest plots for my master thesis. Thankssss.
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?
@@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
@@ricardomorato2875 Muito obrigado pela sua ajuda! Um abraço
@@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.
@@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
Joe Rogan
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.
Thank you very much for this help! Wonderful video!
Very helpful thank you
Thank you so much Mam :)
Excellent!
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?
Im having the same problem
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
@@robertridde6914 Thanks for the reply. That what i did, reslts: same problem
I have the same issue, odds ratio scatter dots are not aligning with the bars
Gwml1jqgik
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.
i have the same problem with changing the red bar to a scatter plot. Did you solve the problem?
The same here
Dang. 3 and a half years later and still saving people like me at work haha. Thank you Erica
very helpful thank you so much <3
Thanks Erica, I was wondering how to show the p values in the graph.
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
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
most comprehensive, clear and instructional vid I have ever come across on youtube...thx
Excellent work. Thanks
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 :)
Hi ! How do I do this ?
@@anjalyjohn5600 Before you delete the right hand axis (for the scatter plot) change its max bound to one higher than your amount of factors.
@@pauldahlke5618 Thanks to you! Finally it worked.
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.
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
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.
@@Leon1Das-MJPZ Thank you so much for your help!
@@mariasanz8643 Did that fix it?
@@Leon1Das-MJPZ yes it did! thanks so much
One question professor, from where you got the initial values, I mean lower, upper, and Odds?
That would be data extracted from literature or from your own investigations.
Does not work under the Office'2013.
Anyone know how to get a bold vertical line on the odds ratio of 1 so that the reference is well seen?
The only way I know how to do it is to manually add a line using the shapes tool.