Category: IT

  1. 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:

  2. Organising data in Excel for analysis, part 2

    Save processing time and manipulate y our data with ease using the Power Query Editor in Excel

  3. 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 […]

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

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

  6. 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 re-use the graph format in different projects - all you need to do is point it to different data sets.

  7. Colourblindness and graphics

    About one in ten males (including myself) have some degree of red-green 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 colour-blindness friendly graphics.

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

  9. Improving photomicrographs

    Photomicrographs looking a bit muddy? I have made some notes on a simple way to improve things.

  10. Teeny fonts in Word’s revisions balloons?

    balloontext01Every now and again I find documents where the revisions balloons are unreadable because the font is wrong. This can be fixed.

Number of posts found: 17