I need to plot non-numeric values in a graph in Excel.

Assume I have the following data... :

X Axis Y Axis
A L
B M
C N
D O
E P
F Q
G R
I want such a graph



R x
Q x
P x
O x
N x
M x
L x
A B C D E F G

i.e. ABCD on the x axis and lmno on the y axis and the small x points are
the plots of AL, BM, CN etc..

Try this:

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

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


Lax wrote:

I need to plot non-numeric values in a graph in Excel.

Assume I have the following data... :

X Axis Y Axis
A L
B M
C N
D O
E P
F Q
G R
I want such a graph



R x
Q x
P x
O x
N x
M x
L x
A B C D E F G

i.e. ABCD on the x axis and lmno on the y axis and the small x points are
the plots of AL, BM, CN etc..