I have a series of worksheets, each representing tournament scores on a
particular pinball machine. Each sheet looks like this:

Player Score LoTR
Me 3,000,000
Her 2,000,000
You 1,000,000

Player names in column A, scores in column B, and the name of that machine
in cell C1.

I want to create a scatter chart like this:

LoTR | * * *
|
AFM | * **
|
ST | * * *
+---------------------------------------
0 1 2 3 4

Where each player score shows up as a data point on the scatter chart, with
scores running along the X axis and (here's the kicker) the text label on
the Y axis. This will enable people to visually ascertain the range and
distribution of scores for each machine.

I'm having trouble setting up the chart. Any help is appreciated. Thanks!