High-resolution Risk of Bias assessment graph… in Excel!

Some years ago, I found myself ranting and raving at the RevMan software kit, which is the official Cochrane Collaboration software suite for doing systematic reviews. Unfortunately, either because I’m an idiot or because the software is an idiot (possibly both), I found it impossible to export a Risk of Bias assessment graph at a resolution that was even remotely acceptable to journals. These days journals tend to accept only vector-based graphics or bitmap images in HUGE resolutions (presumably so they can scale these down to unreadable smudges embedded in a .pdf). At that time I had a number of meta-analyses on my hands so I decided to recreate the RevMan-style risk of bias assessment graph, but in Excel. This way anyone can make crisp-looking risk of bias assessment graphs at a resolution higher than 16dpi (or whatever pre-1990 graphics resolution RevMan appears to use…)

The sheet is relatively easy to use, just follow the embedded instructions. You need (1) percentages from your own risk of bias assessment (2) basic colouring skills that I’m sure you’ve picked up before the age of 3. All you basically do to make the risk of bias assessment graph is colour it in using Excel. It does involve a bit of fiddling with column and row heights and widths, but it gives you nice graphs like these:

Sample Risk of Risk of Bias assessment graph

Sample Risk of Bias Graph

Like anything I ever do, this comes with absolutely no guarantee of any kind, so don’t blame me if this Excel file blows up your computer, kills your pets, unleashes the Zombie Apocalypse or makes Jason Donovan record a new album.


 

Download available here (licensed under Creative Commons BY-SA):

UPDATE September 2016 – a friendly e-mailer noted that the sheet was protected to disallow column formatting (which makes the thing useless). Version 2.4 corrects this.

UPDATE January 2017 – another friendly person noted that I’m an idiot and hadn’t fixed the column formatting problem in the full Cochrane version of the Excel. Will I ever learn? Probably not. Version 2.5 corrects this (and undoubtedly introduces new awful bugs).

Risk of Bias Graph in Excel – v2.5

MD5: BA8F1F1F830742C8E206C86F1BB31089


 

 

7 comments on “High-resolution Risk of Bias assessment graph… in Excel!

  1. Lina Porras says:

    Thank you so much!
    I have to say that the sheets are protected and ask for password, otherwise is not possible to modify the column width… I have to solve that, but the file is really helpful.

    • robin_k says:

      Hi Lina,

      Thanks for your comment! If you follow the steps in the sheet, you shouldn’t need a password. In an old version, you couldn’t change the column width because I made a silly mistake with the sheet protection, but the newest version (version 2.4) should work just fine!

  2. Jin says:

    Thank you so much for sharing! It was very easy to use and extremely helpful!

  3. Sarah says:

    Hey, thanks a lot for this – I can get the 5 criteria to work just fine but the option to change column width in the 7 criteria sheet is greyed out so can’t be clicked. This is despite downloading the 2.4 version. Please could you advise.

    • robin_k says:

      Hi Sarah, thanks for noticing – I forgot to update the permissions for the 7-criteria sheet. Can you try version 2.5? Should work 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *