Check the example he

http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Charles Blaquière" wrote in message
...
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!