Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart wizard will not place (as object in) graph in same sheet | Excel Worksheet Functions | |||
smooth graph lines | Excel Discussion (Misc queries) | |||
Ability 2 put * over single bar in graph 2 indicate stat sig | Charts and Charting in Excel | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
How do I combine two worksheets into one graph | Charts and Charting in Excel |