title: how to plot data in excel for three columns on of which is a distinguishing factor?
body: <p>Say if I have a data in the following format</p>
  <p><a href="https://i.stack.imgur.com/SawUQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SawUQ.png" alt="enter image description here" /></a></p>
  <p>How can I create an XL graph which gives me the Rating in a Subject over time, the lines should be on the same graph ? I tried &quot;Scatter with smooth lines and markers&quot; but it did not bifurcate &quot;A&quot; and &quot;B&quot;</p>
  <p><a href="https://i.stack.imgur.com/pTfS2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pTfS2.png" alt="enter image description here" /></a></p>