How to create a bar chart using Macro?

Hi All,

Please find the sample attachment for your reference.

I need your help in creating bar chart using macro.

In my sample file(Sheet2),I have manually created the Bar Chart.

Now i need to create the same kind of bar chart using macro?

Please help me to create like that and it's an urgent thing.

Thanks in advance.

Regards
Kumar