plot graph and place it in a cell possible?
Given the following table,
description HSP code 3DAF 6DAF 10DAF 15DAF 20DAF ' RIKEN cDNA 1110064A23 [Mus musculus]' '109' 'AA' 0.00126 0.38079 1 0.84427 0.24712 ' putative allergenic protein [Oryza sativa (japonica cultivar-group)]' '446' 'AL' 0.23528 0.25098 1 0.76323 0.30734 ' putative dynamin-like protein [Oryza sativa (japonica cultivar-group)]' '750' 'CSK' 0.003601 0.42652 1 0.87665 0.24654 ' TMV-MP30 binding protein 2C [Nicotiana tabacum]' '105' 'CSK' 0.003812 0.21454 1 0.76468 0.29063 ' putative beta-glucosidase [Oryza sativa (japonica cultivar-group)]' '449' 'CW' 0.003052 0.25375 1 0.89654 0.27934 ' putative DNA ligase [Oryza sativa] gb|AAP54376.1| putative DNA ligase [Oryza sativa (japonica cultivar-group)]' '539' 'DNA' 0.002772 0.10645 1 0.83419 0.23937 ' cyclin T1 [Capra hircus]' '79' 'NSH' 0.001395 0.25319 1 0.83616 0.20009 Is it possible to write a formula in a column after 20DAF and ask excel to plot graph specified with a given size, X-axis labels (i.e. 3, 6, 10, 15, 20) and so later, when i sort all the cells by column of "code", the graphs are also sorted accordingly? If Excel can't do, what else? Matlab seems also not possible? |
All times are GMT +1. The time now is 05:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com