MatrixToVector by tauben

VIEWS: 12 PAGES: 6

More Info
									Matrix -- All formula on this sheet pull data out of this matrix
    1             2         3            4             5           6     7
   11            22        33           44            55          66    77
  111           222       333          444           555         666   777




Matrix To Column -- Returns all of Matrix as a single column, by row or by column
 By Row     ByCol
    1          1
    2         11
    3        111                Matrix To Row -- Returns all of Matrix as a single row, by row or
    4          2                    ByRow           1          2          3
    5         22                    ByCol           1         11        111
    6        222
    7          3
    8         33                Matrix Row -- Returns one row, specified by WhatRow, of Matrix
   11        333                       2       <-- WhatRow
   22          4                      11           22         33         44
   33         44
   44        444
   55          5                Matrix Column -- Returns one column, specified by WhatColumn
   66         55                       4       <-- WhatColumn
   77        555                       4
   88          6                      44
  111         66                     444
  222        666
  333          7
  444         77
  555        777
  666          8
  777         88
  888        888
                 .
                 8
                88
               888




w or by column



trix as a single row, by row or by column.
                   4         5          6    7     8    11   22   33    44
                   2        22         222   3    33   333    4   44   444


ecified by WhatRow, of Matrix

                 55        66         77     88


mn, specified by WhatColumn, of Matrix
55   66    77   88   111   222   333   444   555
 5   55   555    6    66   666    7     77   777
666   777   888
 8     88   888
          Charting Different Groups Of Data Without Using VBA.

Data For Chart
Person    Value A       Value B       Valuie C       Value D       Value E       Value F
Annie               6             2              4             5             2             1
Beth                1             4              3             5             6             8
Cathy               4             1              2             3             8             7
Denise              5             6              8             1             3             2



Person To Chart         Cathy         Change the name of the person to chart each person's data.

Person Scores
        4           1             2              3             8             7


                                                           Values


   9

   8

   7

   6

   5

   4

   3

   2

   1

   0
          Value A         Value B           Valuie C           Value D             Value E     Value F
h person's data.




                   Values




       Value F

								
To top