Plot graph based on a set of table data

taykaisheng

New Member
Joined
Jul 30, 2013
Messages
10
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..
 

Forum statistics

Threads
1,085,865
Messages
5,386,420
Members
401,997
Latest member
cizwiz

Some videos you may like

This Week's Hot Topics

Top