Documents for Excel, .NET Edition Documentation
Manage Data / Use Chart / Work with Chart Types / Pie Chart
In This Topic
    Pie Chart
    In This Topic

    Pie charts, the most common tools used for data visualization, are circular graphs that display the proportionate contribution of each category, which is represented by a pie or a slice. The magnitude of the dependent variable is proportional to the angle of the slice. These charts can be used for plotting just one series with non-zero and positive values.

    GcExcel supports the following types of pie charts.

    Chart Type Chart Snapshot Use Case
    Pie

    Pie chart is used to display a single data series in a circle-type structure, with each sector representing a different category.
    Pie3D

    Pie3D chart is used to display the chart demonstration in 3D which is a modification of 2DPie chart in terms of appearance.
    PieExploded

    PieExploded chart is used to pull all of the slices out of a pie chart and view the sectors separately in pieces.
    PieExploded3D

    PieExploded 3D chart is used display the chart demonstration in 3D which is a modification of 2DPieExploded chart.
    PieOfPie

    PieofPie chart is used to separate the slices from the main pie chart and display them in an additional pie chart.
    BarOfPie

    BarofPie chart is used to separate the slices from the main pie chart and display them in an additional stacked bar chart.
    Doughnut

    Doughnut chart is used to display multiple data series concurrently, with each ring depicting a single data series.
    DoughnutExploded

    DoughnutExploded is used to pull all slices out of a DoughnutExploded chart and view the sectors separately in pieces.

    Using Code

    Refer to the following code to add Doughnut Exploded chart:

    C#
    Copy Code
      public void PieCharts()
      {
          // Initialize workbook
          Workbook workbook = new Workbook();
          // Fetch default worksheet 
          IWorksheet worksheet = workbook.Worksheets[0];
    
          // Prepare data for chart
          worksheet.Range["A1:D4"].Value = new object[,]
    {
         {null, "Q1", "Q2", "Q3"},
         {"Mobile Phones", 1330, 2345, 3493},
         {"Laptops", 2032, 3632, 2197},
         {"Tablets", 6233, 3270, 2030}
    };
          worksheet.Range["A:D"].Columns.AutoFit();
          // Add Pie Chart
          IShape pieChartshape = worksheet.Shapes.AddChart(ChartType.DoughnutExploded, 250, 20, 360, 230);
    
          // Adding series to SeriesCollection
          pieChartshape.Chart.SeriesCollection.Add(worksheet.Range["A1:D4"], RowCol.Columns, true, true);
    
          // Configure Chart Title 
          pieChartshape.Chart.ChartTitle.TextFrame.TextRange.Paragraphs.Add("Annual Sales Record");
    
          // Saving workbook to Xlsx
          workbook.Save(@"22-PieChart.xlsx", SaveFileFormat.Xlsx);
      }