SEQanswers

Go Back   SEQanswers > Introductions



Reply
 
Thread Tools
Old 10-26-2012, 12:03 PM   #1
Giles
Member
 
Location: Birmingham, Al

Join Date: Feb 2010
Posts: 39
Default 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?
Giles is offline   Reply With Quote
Old 10-27-2012, 07:40 AM   #2
Gig77
Member
 
Location: Canada

Join Date: Jun 2012
Posts: 17
Default

Have you tried conditional formatting in MS Excel 2010 or higher?
Gig77 is offline   Reply With Quote
Old 10-27-2012, 08:38 AM   #3
Giles
Member
 
Location: Birmingham, Al

Join Date: Feb 2010
Posts: 39
Default

Yes. Just stumbled into that. Thanks.
Giles is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off




All times are GMT -8. The time now is 12:27 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Single Sign On provided by vBSSO