Which graph?

Y

y

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.
 
A

AlfD

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,if(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
 
Top