I have some data in the following form that I need to chart.
A, 123, 1
B, 234, 1
C, 234, 1
D, 12,1
A, 3435, 2
B, 235, 2
C, 790, 2
D, 939, 2
But, I cannot figure how to. I want a line graph with column 1 as the lines, column 2 as the y-axis and column 3 as the x-axis. But I cannot find away to tell it that A, 123, 1 and A, 3435. 2 should be part of the same line. It thinks everything in column 1 is unique. Do I have to reformat my data so the A, B, C, D data are in seperate columns or can I make the chart understand this?
A, 123, 1
B, 234, 1
C, 234, 1
D, 12,1
A, 3435, 2
B, 235, 2
C, 790, 2
D, 939, 2
But, I cannot figure how to. I want a line graph with column 1 as the lines, column 2 as the y-axis and column 3 as the x-axis. But I cannot find away to tell it that A, 123, 1 and A, 3435. 2 should be part of the same line. It thinks everything in column 1 is unique. Do I have to reformat my data so the A, B, C, D data are in seperate columns or can I make the chart understand this?