
Using VBA, you can generate charts based on certain criteria. Let us take a look at it using an example.
Step1 − Enter the data against which the graph has to be generated.

Step2 − Create 3 buttons – one to generate a bar graph, another to generate a pie chart, and another to generate a column chart.

Step3 − Develop a Macro to generate each one of these type of charts.
' Procedure to Generate Pie Chart Private Sub fn_generate_pie_graph_Click() Dim cht As ChartObject For Each cht In Worksheets(1).ChartObjects cht.Chart.Type = xlPie Next cht End Sub ' Procedure to Generate Bar Graph Private Sub fn_Generate_Bar_Graph_Click() Dim cht As ChartObject For Each cht In Worksheets(1).ChartObjects cht.Chart.Type = xlBar Next cht End Sub ' Procedure to Generate Column Graph Private Sub fn_generate_column_graph_Click() Dim cht As ChartObject For Each cht In Worksheets(1).ChartObjects cht.Chart.Type = xlColumn Next cht End Sub
Step4 − Upon clicking the corresponding button, the chart is created. In the following output, click on generate Pie Chart button.

Next topic:-Click Here
Pingback: VBA - Text Files - Adglob Infosystem Pvt Ltd