title: How to build a line graph from two data sets in one table in Excel
body: <p>I'm having an issue with Excel to which I can't find an accurate solution online.</p>
  
  <p>I have this table:</p>
  
  <pre><code>PERSON   |  DATE  |   SIZE
  ==========================
  Matt     |  1-10  |   90.1
  Jane     |  1-10  |   71.3
  Matt     |  1-11  |   90.0  
  Jane     |  1-11  |   71.0
  Matt     |  1-12  |   89.6
  Jane     |  1-13  |   70.2
  </code></pre>
  
  <p>And so on...</p>
  
  <p>The thing is that this is the best solution for inputting this kind of data. I can't have two different tables, one for each person involved, because more people will probably be involved later on, and they all should be included in the same table.</p>
  
  <p>As you can see, the idea is to monitor their weights. And this would be better achieved visually by a line graph that can tell each person what their progress is.</p>
  
  <p>To this end, I would like to set up one graph that shows each person's progress individually as a different line. Like this:</p>
  
  <p><img src="https://i.stack.imgur.com/CrZSH.jpg" alt="enter image description here"></p>
  
  <p>I was wondering if there was any way of having Excel automatically build this line graph using this table but ordering values according to <em>if cell X has value...</em>.</p>
  
  <p>Not being able to find that, I also tried to set up an <em>invisible</em> table that would gather each set in its own column. For that, I was thinking of using an IF statement but I can't seem to find a way of getting that to populate a separate table, row by row, with the data from the original table. On the Internet I can only find how to add up all the values in a certain cell if another certain cell has X value.</p>
  
  <p>I was wondering if anyone out there could give me a hand with this. Thanks in advance!</p>