title: how to get rid of duplicate date in excel line chart?
body: <p>I am using excel track my stock PnL. both 3/1 and 3/2 I have 2 trades. in the line chart, I only want to use the last data of the day.</p>
  
  <pre><code>date   return
  3/1/19  2%
  3/1/19  1%
  3/2/19  3%
  3/2/19  4.5%
  3/3/19  6%
  </code></pre>
  
  <p>this is what I want to show on the line chart.  how do I do that?</p>
  
  <pre><code>date   return
  3/1/19  1%
  3/2/19  4.5%
  3/3/19  6%
  </code></pre>