How to create multiple bar charts at the same time?

Joined
Oct 28, 2015
Messages
1
Reaction score
0
Hi

I have a set of data for 500 companies in my excel.
The company names are in column A. And the corresponding monthly data for 12 months are in the columns
B to M.

Now I want to know if there is any automation method to create 500 bar charts (in a different sheet) at the same time. Each bar chart should have 12 bars for the 12 months data.

I came across some macro for doing the same for pie charts.
https://www.pcreview.co.uk/threads/using-automation-in-excel-to-create-multiple-charts.2807098/

Please help me in this way for bar charts.

Thanks.
 
Back
Top