Erica Lee
Erica Lee
  • Видео 2
  • Просмотров 244 196
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))

Комментарии

  • @ElaLaelasari-x2v
    @ElaLaelasari-x2v 8 месяцев назад

    Thank you for sharing a good tutorial

  • @kcg4633
    @kcg4633 9 месяцев назад

    Thank You

  • @chrisfox880
    @chrisfox880 Год назад

    Life saver, thank you!

  • @samkab677
    @samkab677 Год назад

    How to interpret results?

  • @marcoswelker132
    @marcoswelker132 Год назад

    Very nice. Well explained. Thank you for sharing ;)

  • @enriquevalentin5245
    @enriquevalentin5245 Год назад

    I'm so thankful!!!!! :))))

  • @traviswhitfill509
    @traviswhitfill509 2 года назад

    This was SO helpful. Thank you so much!

  • @imenemansouri4325
    @imenemansouri4325 2 года назад

    Thank you very much for this video super helpful. I would lover to follow you on twitter if you have one ;)

  • @theflamekid
    @theflamekid 2 года назад

    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
      @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-rv9ge
    @HuyNguyen-rv9ge 3 года назад

    Erica, can you let me know where I should click to get countdown? as you did so fast and can not see it.

  • @shuktatube5333
    @shuktatube5333 3 года назад

    An excellent explanation for me. Thank you!

  • @haihuang7529
    @haihuang7529 3 года назад

    thank you very much

  • @Ftrtts.
    @Ftrtts. 3 года назад

    Thank you so much!! I really didn't know how I was going to graph my odds ratio so this really helped!

  • @bjfiero47
    @bjfiero47 3 года назад

    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".

  • @VictorAntares
    @VictorAntares 3 года назад

    Thank you. My committee loved the plot. And I guess the reviewers did too.

  • @mamadouadamasow9477
    @mamadouadamasow9477 3 года назад

    Very good, thanks

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

    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
      @chukwuemekaogbu8037 Год назад

      Yes. It does not for 8 factors too. Do you know any video where i can watch how to do this?

  • @pragalathannaidoo7845
    @pragalathannaidoo7845 3 года назад

    Thank You. Explained well.

  • @majoramirez7767
    @majoramirez7767 3 года назад

    You are amazing!!! thanks!

  • @osupermono
    @osupermono 3 года назад

    Hi Erica, you don't know how many times I said "I love you"

  • @katiebeckerwa
    @katiebeckerwa 3 года назад

    THANK YOU THANK YOU THANK YOU!!!!

  • @painless263
    @painless263 3 года назад

    wow. this was very helpful and easy to follow. My forrest plot looks great. Thank you!

  • @yongwoon96
    @yongwoon96 3 года назад

    한국인 이신가여??

  • @abbyscurfield2035
    @abbyscurfield2035 3 года назад

    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?

  • @petraschultz384
    @petraschultz384 3 года назад

    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.

  • @olusegunadewaleadeyemi2499
    @olusegunadewaleadeyemi2499 3 года назад

    Thank you Erica, you are a life saver

  • @fazeelzubair2787
    @fazeelzubair2787 3 года назад

    how to draw diamond estimate?

  • @esawibowo5711
    @esawibowo5711 3 года назад

    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

  • @ricardomorato2875
    @ricardomorato2875 3 года назад

    Thank you! You have just helped me a lot! Made some forest plots for my master thesis. Thankssss.

    • @nunodenoronha
      @nunodenoronha 3 года назад

      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?

    • @ricardomorato2875
      @ricardomorato2875 3 года назад

      @@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

    • @nunodenoronha
      @nunodenoronha 3 года назад

      @@ricardomorato2875 Muito obrigado pela sua ajuda! Um abraço

    • @nunodenoronha
      @nunodenoronha 3 года назад

      @@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.

    • @ricardomorato2875
      @ricardomorato2875 3 года назад

      @@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

  • @youngmoneymahini
    @youngmoneymahini 3 года назад

    Joe Rogan

  • @diegoramonfaur7837
    @diegoramonfaur7837 3 года назад

    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.

  • @maribres
    @maribres 3 года назад

    Thank you very much for this help! Wonderful video!

  • @toyvousamaki
    @toyvousamaki 4 года назад

    Very helpful thank you

  • @jenniferangel9803
    @jenniferangel9803 4 года назад

    Thank you so much Mam :)

  • @statisticstime4734
    @statisticstime4734 4 года назад

    Excellent!

  • @markeid11
    @markeid11 4 года назад

    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?

    • @daviskibo1
      @daviskibo1 3 года назад

      Im having the same problem

    • @robertridde6914
      @robertridde6914 3 года назад

      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

    • @daviskibo1
      @daviskibo1 3 года назад

      @@robertridde6914 Thanks for the reply. That what i did, reslts: same problem

    • @flash2hridya
      @flash2hridya 3 года назад

      I have the same issue, odds ratio scatter dots are not aligning with the bars

    • @nycollassilva3558
      @nycollassilva3558 Год назад

      Gwml1jqgik

  • @anthonybavry2642
    @anthonybavry2642 4 года назад

    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.8565
      @andreib.8565 4 года назад

      i have the same problem with changing the red bar to a scatter plot. Did you solve the problem?

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

      The same here

  • @tigerlitam9422
    @tigerlitam9422 4 года назад

    Dang. 3 and a half years later and still saving people like me at work haha. Thank you Erica

  • @boudebabaabdelghafour3000
    @boudebabaabdelghafour3000 4 года назад

    very helpful thank you so much <3

  • @kristianj.salasespinoza3582
    @kristianj.salasespinoza3582 4 года назад

    Thanks Erica, I was wondering how to show the p values in the graph.

  • @drlalatendumoharana
    @drlalatendumoharana 4 года назад

    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

  • @leahdodds9242
    @leahdodds9242 4 года назад

    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-xx4fh
    @gm-xx4fh 4 года назад

    most comprehensive, clear and instructional vid I have ever come across on youtube...thx

  • @aakashrahman7652
    @aakashrahman7652 4 года назад

    Excellent work. Thanks

  • @mayraysann7480
    @mayraysann7480 4 года назад

    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 :)

    • @anjalyjohn5600
      @anjalyjohn5600 4 года назад

      Hi ! How do I do this ?

    • @pauldahlke5618
      @pauldahlke5618 4 года назад

      @@anjalyjohn5600 Before you delete the right hand axis (for the scatter plot) change its max bound to one higher than your amount of factors.

    • @meenamaharjan3882
      @meenamaharjan3882 4 года назад

      @@pauldahlke5618 Thanks to you! Finally it worked.

  • @ericengels2116
    @ericengels2116 4 года назад

    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.

  • @marias4137
    @marias4137 4 года назад

    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-MJPZ
      @Leon1Das-MJPZ 4 года назад

      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.

    • @mariasanz8643
      @mariasanz8643 4 года назад

      @@Leon1Das-MJPZ Thank you so much for your help!

    • @Leon1Das-MJPZ
      @Leon1Das-MJPZ 4 года назад

      @@mariasanz8643 Did that fix it?

    • @mariasanz8643
      @mariasanz8643 4 года назад

      @@Leon1Das-MJPZ yes it did! thanks so much

  • @fezalikhan
    @fezalikhan 4 года назад

    One question professor, from where you got the initial values, I mean lower, upper, and Odds?

    • @Leon1Das-MJPZ
      @Leon1Das-MJPZ 4 года назад

      That would be data extracted from literature or from your own investigations.

  • @alexanderbichev6897
    @alexanderbichev6897 4 года назад

    Does not work under the Office'2013.

  • @brianac7273
    @brianac7273 4 года назад

    Anyone know how to get a bold vertical line on the odds ratio of 1 so that the reference is well seen?

    • @loriegabidel
      @loriegabidel 4 года назад

      The only way I know how to do it is to manually add a line using the shapes tool.