Create Charts Using Excel VBA

     Webhosting by Godaddy     MS Excel Books
Home More Excel (VBA) Training Videos

We can create charts using Excel VBA quickly and easily. Creating charts can be the starting point for creating dashboards. There are two types of charts in MS Excel: one type of chart is created on its own worksheet and is known as a chart object  and the other type of chart is an embedded chart in the worksheet next to the data and is called a chartobject. Chart sheets are defined as members of the workbook charts collection. A chart embedded in a worksheet is a member of the worksheet chartobjects collection. This may sound a little confusing but as you work with the sample VBA codes you will understand this concept quickly.
Below is the code for creating a column chart on a separate chart sheet using VBA:

Sub createmychart()
Dim chart1 As Chart
Set chart1 = Charts.Add
chart1.SetSourceData Source:=Worksheets("sheet1").Range("A1").CurrentRegion, PlotBy:=xlColumns
chart1.ChartType = xlColumnClustered
End Sub

Watch the Excel training video:


Watch the video on YouTube

Create Charts Excel VBA

Home More Excel (VBA) Training Videos