How to make a forest plot in excel

Turn a bar chart into a forest plot
---------------------------------------------------------------------------------
#exceltutorials #excelcharts #exceltips

Microsoft Office 365, Beta Channel, Version 2202
---------------------------------------------------------------------------------

[XerxesBreakSama]

For you to graph the confidence interval properly, you have to create two columns for "Graph upper 95% CI (Upper CI minus RR)" and Graph for lower 95% CI (RR minus lower CI). These are the variables you need when specifying the values for your error bars.

[brannigandupreez]

Hello, Karina.

I'd watch this even if I don't need it. But I just want to thank you so much for making a difference in the lives of many.

Thank you so much for helping me during my thesis write-up. You made the learning process more enjoyable! 😃

[nicholascrabb]

Hardly ever comment on YouTube videos, but this has been so helpful, thank you. Really like how quick and to the point you are, and that you don't ask for anything. Weirdly makes me want to support you on Patreaon or Kickstarter - are you an evil genius, lol? Many thanks again!

[fuhlerei]

So short, so simple, very good explained! Look so many explanation but only yours bring light into the dark.

[DrPKSingh-clwv]

you need to subtract odds value with upper bound for CI+ value and lower bound with odds ratio for CI- value. then only you can get the actual plot of lower and upper confidence interval

[karolperez]

Wow! This was so simple and straight forward. Thank you so much for saving my brain!

[rajivpatel]

That was awesome. Simple and straightforward. Thank you!

[xiaoli]

It's really helpful!! This works well compared with other methods introduced by other youtuber
Thank you!

Great video! Very clear and concise. Thank you!

[shiruit]

This is exactly what I'm looking for. Thanks Karina!

[Chartomy]

Thank you for saving my meta-analysis 🙏🏽🙏🏽🙏🏽

[bluebird]

Hi, I'm wondering why the lower and upper confidence intervals don't match up with the line we created.

[oLrereion]

My values are effect sizes, and some of the lower bound of the confidence intervals are negative. When I select the data for the positive and negative error values, the error bars do not show negative values. Is there something else I need to do? By the way thank you for your video

[TheWhiteguard]

Hi Karina, how can i get the CI+ and CI- i have all the raw data and i also calculated the odds ratio

[jankicheese]

What kind of error bars do you add? Standard error or STD?

[Investmentsindustrytradedepart]

Hi. Could you help with creating forest plot please?

[anilpaul]

I have question how to match exact letters or word in excel like eg: Anil-C1 AnilPaul-C1 so i need C1 status and confirmed as C1 status

[anilpaul]

How to match exact words or letters in two data like example: anil-C1 and AnilPaul-C1 so i need C-1 status is exact match

[intercardioLSD]

Hi, I'm wondering why the lower and upper confidence intervals don't match up with the line we created. any one knows?

[anilpaul]

I have question how to match exact letters or word in excel like eg: Anil-C1 AnilPaul-C1 so i need C1 status and confirmed as C1 status