To add a pie 2D chart, add the data source on worksheet firstly:
using unvell.ReoGrid; // ... var worksheet = this.grid.CurrentWorksheet; worksheet["A2"] = new object[,] { { null, 2008, 2009, 2010, 2011, 2012 }, { "City 1", 3, 2, 4, 2, 6 }, };
Define 2 ranges, data source range and title range, add these ranges into highlight ranges collection:
var dataRange = worksheet.Ranges["B3:F3"]; var titleRange = worksheet.Ranges["B2:F2"]; worksheet.AddHighlightRange(dataRange); worksheet.AddHighlightRange(titleRange);
Result:
Create the pie chart instance:
Chart.Chart c1 = new Chart.Pie2DChart { Location = new Graphics.Point(220, 160), Size = new Graphics.Size(400, 260), Title = "2D Pie Chart Sample", DataSource = new WorksheetChartDataSource(worksheet, RangePosition.Empty, dataRange) { CategoryNameRange = titleRange, }, };
Add the chart instance into worksheet, the chart will be displayed instantly:
worksheet.FloatingObjects.Add(c1);
The result: