Adding a Pie Chart

You can create different types of pie charts such as Pie, Pie3D, PieDoughnut, PieExploded, PieExploded3D, or PieExplodedDoughnut. The following image displays a pie chart.

Using Code

The following code creates a pie chart.

  1. Create values with the SpreadDataSeries class.
  2. Create a chart title and legend.
  3. Set the ChartType property.
  4. Add the chart.
CS
Copy Code
GrapeCity.Xaml.SpreadSheet.Data.SpreadDataSeries series0 = new GrapeCity.Xaml.SpreadSheet.Data.SpreadDataSeries();
series0.Name = "Series 0";
series0.Values.Add(1.0);
series0.Values.Add(2.0);
series0.Values.Add(4.0);
series0.Values.Add(8.0);

GrapeCity.Xaml.SpreadSheet.Data.ChartTitle label = new GrapeCity.Xaml.SpreadSheet.Data.ChartTitle();
label.Text = "Pie Point Chart";
label.FontSize = 10;
label.FontFamily = new FontFamily("Tahoma");
GrapeCity.Xaml.SpreadSheet.Data.Legend l = new GrapeCity.Xaml.SpreadSheet.Data.Legend();
l.Alignment = GrapeCity.Xaml.SpreadSheet.Data.LegendAlignment.TopLeft;

GrapeCity.Xaml.SpreadSheet.Data.SpreadChart chart = new GrapeCity.Xaml.SpreadSheet.Data.SpreadChart();
chart.ChartTitle = label;
chart.Legend = l;
chart.DataSeries.Add(series0);
// chart.DataSeries.Add(series1);
chart.ChartType = GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.Pie;
chart.Name = "name1";
this.gcSpreadSheet1.ActiveSheet.Charts.Add(chart);
VB
Copy Code
Dim series0 As New GrapeCity.Xaml.SpreadSheet.Data.SpreadDataSeries()
series0.Name = "Series 0"
series0.Values.Add(1.0)
series0.Values.Add(2.0)
series0.Values.Add(4.0)
series0.Values.Add(8.0)

Dim label As New GrapeCity.Xaml.SpreadSheet.Data.ChartTitle()
label.Text = "Pie Point Chart"
label.FontSize = 10
label.FontFamily = New FontFamily("Tahoma")
Dim l As New GrapeCity.Xaml.SpreadSheet.Data.Legend()
l.Alignment = GrapeCity.Xaml.SpreadSheet.Data.LegendAlignment.TopLeft

Dim chart As New GrapeCity.Xaml.SpreadSheet.Data.SpreadChart()
chart.ChartTitle = label
chart.Legend = l
chart.DataSeries.Add(series0)
' chart.DataSeries.Add(series1)
chart.ChartType = GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.Pie
chart.Name = "name1"
GcSpreadSheet1.ActiveSheet.Charts.Add(chart)
See Also

 

 


Copyright © GrapeCity, inc. All rights reserved.