Charting Question

Hi all - 

This should be simple but I seem to be stuck. I would like to create a categorical XY chart with a line for each molecule, each with 8 data points (they could be values for assays 1 through 8). There can be hundreds of molecules so it's not practical to enter each of these as Y properties. The data looks like this: 

ActivityName
1
8
107
110
103
104
94
104
Molecule54855
2
3
4
3
2
1
4
5
Molecule86433
2
11
15
10
9
8
19
18
Molecule97998
4
2
1
2
4
6
1
1
Molecule98029

Any ideas??

Thanks - Ton