{"id":2921,"date":"2017-10-11T02:21:25","date_gmt":"2017-10-11T02:21:25","guid":{"rendered":"http:\/\/excelvbatutor.com\/?page_id=2921"},"modified":"2020-04-23T10:58:53","modified_gmt":"2020-04-23T10:58:53","slug":"excel-vba-lesson-24-creating-charts-graphs-excel-vba","status":"publish","type":"page","link":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-lesson-24-creating-charts-graphs-excel-vba\/","title":{"rendered":"Excel VBA Lesson 24: Creating Charts and Graphs in Excel VBA"},"content":{"rendered":"\n

<<Lesson 23>><\/a> [Contents]<\/a> <<Lesson 25>><\/a><\/strong><\/h4>\n\n\n\n

In Excel VBA, we can write code to create charts and graphs easily based on the data on the spreadsheet. Excel VBA has made charting engine as part of the Shape object. It is also an object by itself. We can create charts on a sheet of their own or embed them into an existing worksheet. The chart sheet is the Chart object whereas the embedded chart is part of the shape collection for the worksheet.<\/p>\n\n\n\n

24.1 Creating a Pie Chart<\/h3>\n\n\n\n

To create a pie chart in a spreadsheet, first of all, you need to enter a range of data in a spreadsheet. After entering the data, you need to name the range by right-clicking the range and clicking define the name in the pop-up menu. Name the chart MyChart<\/p>\n\n\n\n

Now insert a command button and then click it to enter the following code in the Excel VBA editor<\/p>\n\n\n\n

Private Sub CommandButton1_Click()<\/p>\n\n\n\n

ActiveSheet.Shapes.AddChart.Select
\nActiveSheet.Shapes(1).Top = 10
\nActiveSheet.Shapes(1).Left = 10
\nActiveChart.ChartType = xl3DPie
\nActiveChart.PlotArea.Select
\nActiveChart.SetSourceData Source:=Range(“MyChart”)
\nActiveChart.HasTitle = True
\nActiveChart.ChartTitle.Text = “My Chart”<\/p>\n\n\n\n

End Sub<\/p>\n\n\n\n