VBA for Excel 2007 tutorial-pie chart


Pie chart

In this VBA code example, you will learn to create a simple pie chart as shown below. The data used in pie chart must be in one row or one column. The category of the data should not greater than 7. One category will be one piece of the chart. The total of all data points from all categories represents 100% of the chart. To add a pie chart to the Excel sheet, you can use the ChartType property of the current active chart(ActiveChart.ChartType=xl3DPie).

VBA for Excel: VBA example code to create a pie chart

To run this VBA example code, you can copy and paste the VBA code below in to the block of Worksheet_Activate() procedure. To open this block, double-click the current worksheet, then in the objects dropdown list select Sheet1 and in events list select Activate.



VBA code for this example:



Option Explicit
Private Sub Worksheet_Activate()
 
    'Select the data source
    Range("A1:G2").Select
    'Create a clusted column chart
    ActiveSheet.Shapes.AddChart , 10, 100
    ActiveSheet.Shapes(1).Select
    ActiveChart.SetSourceData Source:=Range("Sheet1!$A$1:$G$2"), PlotBy:=xlRows
    'Specify Pie chart type
    ActiveChart.ChartType = xl3DPie
 
End Sub 

Comments





This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.