title: Excel Macro: How to loop a chart making macro through a specific column every time the name in that column changes
body: <p>Alright so my goal is to create a chart making macro since I have about 90-some different Station name; and Each station needs it's own chart.</p>
  
  <p>The multiple series I would like to use are my estimated CFS, simulated CFS, stress period number (no.), and the Station Name. I'm attempting to make simple xy scatter line graphs where the No. value would be my x range, and the est:CFS and sim:CFS would both be my y ranges to create 2 rather simple lines.</p>
  
  <p>Now my problem is simply: How should I design the code in VBA so that it knows to stop receiving data for a series in the chart for Niobrara River Station chart, and start using the following data the Snake River station chart... and on so forth until it loops through all 90-some charts.</p>
  
  <p>I'm stumped on how to phrase a command to loop through and read that Station Name column and for it to understand that all those rows that correspond to that station belong to it, and for it to understand that's all the data it needs for one chart while when the station changes I'd like it to move on to the next.</p>
  
  <p>The image below shows how the data on the worksheet is laid out:</p>
  
  <p><img src="https://i.stack.imgur.com/rYJMb.png" alt="worksheet"></p>
  
  <p>I apologize if that's a little difficult to understand if there is any more information I can provide to make my question more clear I'd be happy to post more.</p>