SEQanswers

SEQanswers (http://seqanswers.com/forums/index.php)
-   Introductions (http://seqanswers.com/forums/forumdisplay.php?f=22)
-   -   integer to R,G,B (http://seqanswers.com/forums/showthread.php?t=24476)

Giles 10-26-2012 12:03 PM

integer to R,G,B
 
I'm toying w/ the various heatmap generation programs and find them all far too laborious for what I need. I have a series of locations, and a data value associated with each location. So thats 2 columns for the first experiment, and then an additional column for each additional dataset. Can anyone tell me the best software for doing this? I tried using seqMiner and Mayday and I can't quite get what I want. Mainly, I can't get it to 'tune' the color gradients into a meaningful fashion. Ideally, i'd be able to convert each one of my data points into an r,g,b value; and then have a cell get filled w/ that value. Then i can sort the field based on the value in column1, and just make a tif out of the entire spreadsheet. I can re-size the spreadsheet accordingly to get all the cells in the image. Does anyone know of any easy way to do this?

Gig77 10-27-2012 07:40 AM

Have you tried conditional formatting in MS Excel 2010 or higher?

Giles 10-27-2012 08:38 AM

Yes. Just stumbled into that. Thanks.


All times are GMT -8. The time now is 07:55 AM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2021, vBulletin Solutions, Inc.