Document Solutions for Excel, .NET Edition | Document Solutions
Features / Chart / 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.

    DsExcel supports the following types of pie charts.

    Chart Type Chart Snapshot Use Case
    Pie

    Pie chart

    Pie chart

    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

    Pie3D chart

    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

    PieExploded chart

    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

    PieExploded 3D chart

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

    PieofPie chart

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

    BarofPie chart

    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

    Doughnut chart

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

    DoughnutExploded chart

    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);
      }