How to create a bar chart using Macro?

[ravikumar00008]

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

[royUK]

Start by using the Macro Recorder

[ravikumar00008]

Hi Roy,

Can you please explain a bit detailed.

Regards
Kumar

[royUK]

I've put a link on how to record a macro above. You set the macro recorder running and create the chart manually. This will generate the basic code.