View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Torsbyn Torsbyn is offline
external usenet poster
 
Posts: 2
Default Plot data from column to matrix

I have set of data labelled by two arguments in in three columns. I like to
plot the data in a matrix form instead. How can i do that? Example below.

Current set up:

Data Argument 1 Argument 2
test 1 A 2
test 2 B 5
test 3 E 1
test 4 A 2
desired set up

A B C D E
1
test 3

2 test 1, test 4

3

4

5 test 2


All help most welcome!

/Mikael