Trying to do a line graph but it only displays one value
Hey guys,
so I'm trying to do a line graph in excel. Basically I have 3 groups, two intervention groups and one control group. In each group are about 20 people. There are three measurement points across 15 months. I am now trying to display the progress/change of each single person across those measurement points. So like 20 lines beneath each other and one line displays one person. Problem is, when I mark the values (which I imported from SPSS) and insert a line graph it shows me one single point in it and every value in my spreadsheet is inserted as an axis label and not as a value in the graph. And also suddenly only one line and one column is marked. What am I doing wrong? How do I make it into an adequate graph?
More info: I am a beginner, my Excel is set to German, i am using a windows pc and the version is 2601.
[link] [comments]
Want to read more?
Check out the full article on the original site