plot graph and place it in a cell possible?

R

Ross

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?
 
Top