title: Multiple Y values for a single X in SSRS line\scatter chart
body: <p>I've looked online but didn't find the answer I needed.</p>
  
  <p>In SSRS 2008 I have a data set that returns results similiar to this:</p>
  
  <pre><code>Category Value
  -------- -----
  18       35
  18       42
  26       45
  30       50
  30       42
  40       50
  </code></pre>
  
  <p>As you can see, a single category (or X axis) value (such as 18) may have multiple series (or Y axis)  values (for 18 those values are 35 <strong>and</strong> 42). 
  When trying to plot this in a SSRS-2008 report chart, I am only able to display a single Y value for each X - max,min,average,first etc.</p>
  
  <p>What I do need is to display a chart similiar to <a href="http://imageshack.us/f/34/chartexk.png/" rel="nofollow noreferrer">this</a>:
  <a href="http://img34.imageshack.us/img34/3990/chartexk.png" rel="nofollow noreferrer">MyChart http://img34.imageshack.us/img34/3990/chartexk.png</a>.
  Do you have any ideas on how to implement this?</p>
  
  <p>Thanks for any answer!</p>