Plot graph based on a set of table data

[taykaisheng]

Hi, 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

View image: VBA1
*I got no idea why i can't attach the picture here, so I pasted the link here =/*

However as the table data was generated out from another automation tool thus the number of rows can be increase or decrease. And the problem was due to 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".


And these are the expected output of the chart

View image: graph1
*I got no idea why i can't attach the picture here, so I pasted the link here =/*

Hope some kind soul could help me on this..