title: Merging two separate data series into one Excel Chart with different X axis points
body: <p>I have two data sets that I want to graph, some share the same X-axis values some do not.</p>
  
  <p><strong>Data Set 1</strong></p>
  
  <pre><code>X         Y
  9:30:29   5
  9:31:00   6
  9:32:00   7
  </code></pre>
  
  <p><strong>Data Set 2</strong></p>
  
  <pre><code>X         Y
  9:30:29   4
  9:31:03   3
  9:32:00   2
  9:33:01   1
  </code></pre>
  
  <p>I want to graph Data Set 1 and Data Set2 in an area graph, so Data Set 1 and 2 will share X-axis point <code>9:30:29</code> and <code>9:32:00</code> </p>
  
  <p>What I am running into is when I graph the second set, it basically overlays the Y data on the same X axis points from Data Set 1. </p>