Category: IT

Recovering numeric data from an image of a graph
Sometimes all you have is an image file (perhaps from a scanned publication) and you would like to convert the data points to xy coordinates (maybe you want to try an analysis on someone else's data). R gives some tools to help. Here is the start of some code:renfreeshawlab.science.unimelb.edu.au/2020/07/04/recoveringnumericdatafromanimageofagraph

Organising data in Excel for analysis, part 2
Save processing time and manipulate y our data with ease using the Power Query Editor in Excelrenfreeshawlab.science.unimelb.edu.au/2018/09/17/organisingdatainexcelforanalysis2

Organising data in Excel for analysis
From time to time I get asked to help with a statistical analysis. When I ask for the data I often get a spreadsheet like this. OK, I can read this and sometimes make sense of it, but there are a number of important issues including: With a little bit of learning, this can all […]renfreeshawlab.science.unimelb.edu.au/2018/09/04/organisingdatainexcelforanalysis

Monochrome conversion of colour immunofluorescence or in situ images
It is easy to convert colour immuno or in situ figures to monochrome whilst emphasizing the positive staining colour and repressing the background stain. 
How to get more pixels when you export Powerpoint slides to graphic files
Getting around Microsoft's limitations to export high quality graphics from Powerpoint is not too hard once you know how. 
Prettier graphs using Excel
Excel excels at ugly graphs, However it can produce nice graphs if you know how. It takes a little thought, and a little effort to transform the default graphs, setting sizes, spacing, colours, fonts, formats, but once you are familiar, it takes little time, and once you have a nice format you can even reuse the graph format in different projects  all you need to do is point it to different data sets.renfreeshawlab.science.unimelb.edu.au/2017/03/01/prettiergraphsusingexcel

Colourblindness and graphics
About one in ten males (including myself) have some degree of redgreen colour blindness (and 0.5% of females), so you should bear that in mind when you are making graphics to display to others. Here are some suggestions for making colourblindness friendly graphics.renfreeshawlab.science.unimelb.edu.au/2016/10/10/colourblindnessandgraphics

Loading sets of images into powerpoint slides
Sometimes one may want to generate a PowerPoint slide with a set of images  for example a set of micrograph images to discuss with your colleagues (or a lovely set of your holiday photos to make your friends jealous). You can do this by manually adding each image, one by one, then resizing, repositioning, formatting .... , but there is a much quicker way. Here is a guide to automating the process.renfreeshawlab.science.unimelb.edu.au/2016/10/08/loadingsetsofimagesintopowerpointslides

Improving photomicrographs
Photomicrographs looking a bit muddy? I have made some notes on a simple way to improve things.renfreeshawlab.science.unimelb.edu.au/2016/05/06/improvingphotomicrographs

Teeny fonts in Word’s revisions balloons?
Every now and again I find documents where the revisions balloons are unreadable because the font is wrong. This can be fixed.renfreeshawlab.science.unimelb.edu.au/2016/03/13/teenyfontsinwordsrevisionsballoons
Number of posts found: 17