Vertical Graph

sacherTorte

New Member
Joined
Jul 26, 2005
Messages
6
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
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

sacherTorte

New Member
Joined
Jul 26, 2005
Messages
6
Hi Paddy, just to give you an idea. You may laugh about the assessment... ;)
052911.xls
ABCD
2ArtConsultingInvestmentbankingBMWTrainee
3Income454
4Careeropportunities552
5Work-Life-Balance452
Gesamtübersicht
 

Watch MrExcel Video

Forum statistics

Threads
1,118,372
Messages
5,571,763
Members
412,419
Latest member
acemali
Top