Pie 2D Chart

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:

240

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:

241


Was the content of the page helpful?