Erica Lee
Erica Lee
  • 2
  • 242 856
Microsoft Excel - Horizontal Bar Graph - X-Axis Labels with Text
Microsoft Excel - Horizontal Bar Graph - X-Axis Labels with Text
Переглядів: 11 035

Відео

Microsoft Excel - Forest Plots (Odds Ratios and Confidence Intervals)
Переглядів 232 тис.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 6 місяців тому

    Thank you for sharing a good tutorial

  • @kcg4633
    @kcg4633 7 місяців тому

    Thank You

  • @chrisfox880
    @chrisfox880 11 місяців тому

    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 3 роки тому

    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 6 місяців тому

      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 3 роки тому

      @@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 3 роки тому

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

    • @LeonAruba
      @LeonAruba 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 роки тому

      @@LeonAruba Thank you so much for your help!

    • @LeonAruba
      @LeonAruba 4 роки тому

      @@mariasanz8643 Did that fix it?

    • @mariasanz8643
      @mariasanz8643 4 роки тому

      @@LeonAruba yes it did! thanks so much

  • @free.educators
    @free.educators 4 роки тому

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

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