title: How do I create series in Excel using criteria from values in other cells?
body: <p>I have an Excel spreadsheet populated as below:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Latitude</th>
  <th>Longitude</th>
  <th>Altitude</th>
  <th>Value</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>10</td>
  <td>10</td>
  <td>1</td>
  <td>100</td>
  </tr>
  <tr>
  <td>10</td>
  <td>10</td>
  <td>5</td>
  <td>105</td>
  </tr>
  <tr>
  <td>10</td>
  <td>10</td>
  <td>20</td>
  <td>120</td>
  </tr>
  <tr>
  <td>10</td>
  <td>5</td>
  <td>1</td>
  <td>150</td>
  </tr>
  <tr>
  <td>10</td>
  <td>5</td>
  <td>5</td>
  <td>155</td>
  </tr>
  <tr>
  <td>10</td>
  <td>5</td>
  <td>20</td>
  <td>170</td>
  </tr>
  <tr>
  <td>15</td>
  <td>10</td>
  <td>1</td>
  <td>500</td>
  </tr>
  <tr>
  <td>15</td>
  <td>10</td>
  <td>5</td>
  <td>505</td>
  </tr>
  <tr>
  <td>15</td>
  <td>10</td>
  <td>20</td>
  <td>520</td>
  </tr>
  <tr>
  <td>15</td>
  <td>5</td>
  <td>1</td>
  <td>550</td>
  </tr>
  <tr>
  <td>15</td>
  <td>5</td>
  <td>5</td>
  <td>555</td>
  </tr>
  <tr>
  <td>15</td>
  <td>5</td>
  <td>20</td>
  <td>570</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Using this data, I would like to create a Chart in Excel where I have Value on the X-axis, Altitude on the Y-Axis and a series for each unique combination of Latitude and Longitude.</p>
  <p>This should result in 4 series being plotted on the Chart with each series having 3 values (one value for each Altitude. I feel like this should be easy to do but I'm struggling to do it myself or find something using the grand-old Google.</p>
  <p>Any help you could provide this Excel-noob would be greatly appreciated!</p>