ChartTitle = 'Users' 'Save as Excel file workbook. IsSeriesInRows = False 'Position chart in the worksheet chart. Value2 = 12000 'Add a pie chart and set data range in the worksheet Dim chart As IChartShape = worksheet. Value = 'Users' 'Add data from A2 till B4 worksheet. Rotate the slices and increase the gap between them. Kasper Langmann, Co-founder of Spreadsheeto. In the Charts group, click Insert Pie or Doughnut Chart: If you forget which button is which, hover over each one, and Excel will tell you which type of chart it is. Separate a few slices from the pie (or circle) and show how to change their color. Then click to the Insert tab on the Ribbon. Add data labels and data callouts to the pie chart. Worksheets ( 0 ) 'Add sample data for pie chart 'Add headings in A1 and B1. Make a 2-D pie chart in Excel by taking into account the given dataset. Create ( 1 ) 'Get the first sheet Dim worksheet As IWorksheet = workbook. Excel 'Create a workbook Dim workbook As IWorkbook = application. Private Sub CreatePieChart () Using excelEngine As ExcelEngine = New ExcelEngine () 'Instantiate the application object Dim application As IApplication = excelEngine.

How to make a pie chart in excel.