title: need to create salary data with salary bands
body: <p>looking to create a salary chart for all my employees.  should be xy scatter plot with all salary data for my employees grouped by their title.  I want floating bar graph representing salary range for that title. </p>
  
  <p>salary data:</p>
  
  <p>employee,title,salary<br>
  joe, eng 1, 15000<br>
  mike, eng 1, 16000<br>
  kelly, eng 3, 25000<br>
  steve, eng 2, 20000<br>
  jane, eng 3, 30000<br>
  michelle, eng 5, 60000<br>
  anan, eng 5, 70000  </p>
  
  <p>eng level salary band  </p>
  
  <p>title,min, max<br>
  eng 1, 10000, 20000<br>
  eng 2, 15000, 30000<br>
  eng 3, 25000, 40000<br>
  eng 4, 30000, 60000<br>
  eng 5, 50000, 80000<br>
  eng 6, 60000, 100000</p>
  
  <p>note i wont have employees in every level, but want to show that level on the chart,  the levels should be shown left to right on the graph from eng 1 to eng 6</p>
  
  <p>i am having a hard time to figure out how to do this in excel...your help would be appreciated</p>