title: Generate graph automatically based on a set of data table in excel using VBA
body: <p>I'm very new in VBA.. Currently I'm on my project which required me to creating a automation tool by plotting 2 bar chart automatically based on 2 table data as shown below</p>
  
  <p><img src="https://s23.postimg.org/kj9s5jquj/VBA1.jpg"/></p>
  
  <p>However as the table data was generated out from another automation tool thus the number of rows can be increase or decrease. And the number of rows could be more/less than 5, I couldn't select the cells by specifying the address of the cell such as "A7" or "B6".</p>
  
  <p>And these are the expected output of the chart:</p>
  
  <p><img src="https://s18.postimg.org/7xemh4imx/graph1.jpg"/></p>
  
  <p>Hope some kind soul could help me on this..</p>