How to create multiple bar charts at the same time?

Oct 28, 2015
Reaction score

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.

Please help me in this way for bar charts.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question