Charting in Excel is a great way to represent data. The viewer can easily understand data & what exactly going on through charts. In case you need to create too many charts on the same format, then this tutorial is surely going to help you in saving time. In this article, we will learn how to create chart, using VBA code.
Question): I urgently need a way to automatically make a specific type of chart say bar chart or column chart. The data is in fixed formats. Can someone please help?
Following is the picture of data we have:
We need to follow the below steps to launch VB editor
- Click on Developer tab
- From Code group, select Visual Basic
Enter the following code in the standard module
- As we run the macro; we will get the automatic chart. Refer below snapshot
In this way, we can create automated charts, using macros.