Firstly, select the data range with which you want to make the Pie Chart.In this step, I will show you how you can insert the Pie Chart. Using Charts Group to Make a Pie Chart in Excelįor this method, I will use the Charts group to make a Pie Chart in Excel. I will make a Pie Chart using this dataset.ġ. This dataset contains the Course Name and Average Number of Present Students in 6 Months. To explain this article, I have taken the following dataset. The first condition of making a Pie Chart in Excel is to make a table of data. Position = ExcelDataLabelPosition.BestFitĭim stream As Stream = File.Create('Output.5 Simple Ways to Make a Pie Chart in Excel 'Open existing workbook with data enteredĭim assembly As Assembly = GetType(Program).GetTypeInfo().Assemblyĭim fileStream As Stream = assembly.GetManifestResourceStream('')ĭim workbook As IWorkbook = (fileStream)ĭim worksheet As IWorksheet = workbook.Worksheets(0)ĭim chart As IChartShape = ()Ĭ = ExcelLegendPosition.Bottom Using excelEngine As ExcelEngine = New ExcelEngine()ĭim application As IApplication = excelEngine.ExcelĪpplication.DefaultVersion = ExcelVersion.Excel2016 Public Shared Sub Main(ByVal args As String()) Stream stream = File.Create('Output.xlsx') IWorksheet worksheet = workbook.Worksheets Stream fileStream = assembly.GetManifestResourceStream('') Open existing workbook with data enteredĪssembly assembly = typeof(Program).GetTypeInfo().Assembly IApplication application = excelEngine.Excel Īpplication.DefaultVersion = ExcelVersion.Excel2016 Using (ExcelEngine excelEngine = new ExcelEngine())

The following C#/ VB.NET complete code snippet shows the creation of pie chart using XlsIO.

To know more about creating charts with various settings using XlsIO, please refer the documentation. NOTE: Applying properties apart from the mentioned list might throw exception or the changes will not be reflected in the output document because those properties are not related to pie chart. IsVar圜olor (All slices will be represented with same color if IsVar圜olor is FALSE) Position = ExcelDataLabelPosition.BestFit īelow is the list of other properties that is applicable for a pie chart.ģ.

How do you create pie chart in excel