Hi all,

I have a serie of data as below:

A 23
C 3
D 4
F 67
D 34
A 56
A 23
F 3
D 7
C 6
D 7
R 12
D 15

I would build a graph with the 5 classes A, C, D, F, R on the x axis and I would use an "*" (or
something like this one) to represent the 3 values about A all in the same vertical line over the
point A in the x axis, the 2 values about C all in the same vertical line over the point C in the x
axis. The same for D values, F values and R values.

Which graph I need? Do you know examples over the net?

Any suggestion or link will be actually appreciated.

Thanks in advance, Alex.

Hi Alex!

This will do it.
I will treat your data as in cells A1:B13

Add a helper column next to column A: this becomes the new column B.
In B1 pu
=if(A1="A",1,if(A1="C",2,if(A1="D",3,if(A1="F",4,i f(A1="R",5)))))
(Simply converts your A,C,D,F,R,to 1,2,3,4,5 respectively)
Copy this down to B13.
Now plot columns B,C using the XY scatter graph.
Don't choose a graph with lines joining the points. It's easy to chang
the symbol for a point if you don't like Excel's default.

Al

--
Message posted from http://www.ExcelForum.com

You can complete the chart, putting the letters along the bottom,
following a technique like this:

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

Put your helper series along the bottom of the chart, not up the side.

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

AlfD < wrote:

Hi Alex!

This will do it.
I will treat your data as in cells A1:B13

Add a helper column next to column A: this becomes the new column B.
In B1 put
=if(A1="A",1,if(A1="C",2,if(A1="D",3,if(A1="F",4,i f(A1="R",5))))).
(Simply converts your A,C,D,F,R,to 1,2,3,4,5 respectively)
Copy this down to B13.
Now plot columns B,C using the XY scatter graph.
Don't choose a graph with lines joining the points. It's easy to change
the symbol for a point if you don't like Excel's default.

Alf


---
Message posted from http://www.ExcelForum.com/