Vertical Graph

[sacherTorte]

Hello,

I am a bit stuck, hopefully someone can help me. My problem is as follows:

I have a table of data, actually the grades (1-5) on different criteria (line names in column A) with different decision alternatives (column names in row 1).
What I want to do is to create a graph that actually plots the different decision alternatives as individual lines with the grades as x-axis and the criteria as y-axis. This means that the graph lines should be vertically, oscillating according to the grades 1-5.

I have tried with the regular line plotting, the scattered xy-plotting, but without success. Can somebody help me out?

Thanks,

Sacher

 

[PaddyD]

post up a small sample of your data.

 

[sacherTorte]

Hi Paddy, just to give you an idea. You may laugh about the assessment...

052911.xls
	A	B	C	D
2	Art	Consulting	Investmentbanking	BMWTrainee
3	Income	4	5	4
4	Careeropportunities	5	5	2
5	Work-Life-Balance	4	5	2
Gesamtübersicht