I have been adding a lot of absence/presence data into an MS Excel 2011 for Mac sheet. On the days students are present they get points, on days they are absent they get zero. If student was there, but no marks were given that day I add P for presence. I have one row per student and one column per class day:
Name: D1 D2 D3 Student One 15 0 28 Student Two 12 14 16 Student 3 15 13 P
When I select this entire block with all data to create a line graph I get only one line. I need a line per student. When I select all data except for the labels
Dx I sometimes get data shown for one student, sometimes I get separate lines per student which I want. How can I make sure I will get a line graph per student and all lines in one chart with the y-axis for marks and the x-axis for students?