protected override void OnLoad(EventArgs e) { base.OnLoad(e); var worksheet = grid.CurrentWorksheet; worksheet["A2"] = new object[, ] { { null, 2008, 2009, 2010, 2011, 2012 }, { "City 1", 3, 2, 4, 2, 6 }, }; var dataRange = worksheet.Ranges["B3:F3"]; var titleRange = worksheet.Ranges["B2:F2"]; worksheet.AddHighlightRange(dataRange); worksheet.AddHighlightRange(titleRange); Chart.Chart c1 = new Chart.DoughnutChart { Location = new Graphics.Point(220, 160), Size = new Graphics.Size(400, 260), Title = "Doughnut Chart Sample", DataSource = new Chart.WorksheetChartDataSource(worksheet, titleRange, dataRange, RowOrColumn.Column), }; worksheet.FloatingObjects.Add(c1); }
protected override void OnLoad(EventArgs e) { base.OnLoad(e); var worksheet = grid.CurrentWorksheet; // ソースコードのコメントと説明は「折れ線グラフ(LineChartDemo.cs)」をご覧ください。 worksheet["A2"] = new object[, ] { { null, 2008, 2009, 2010, 2011, 2012 }, { "名古屋", 3, 2, 4, 2, 6 }, }; var dataRange = worksheet.Ranges["B3:F3"]; var titleRange = worksheet.Ranges["B2:F2"]; worksheet.AddHighlightRange(dataRange); worksheet.AddHighlightRange(titleRange); Chart.Chart c1 = new Chart.DoughnutChart { Location = new Graphics.Point(220, 160), Size = new Graphics.Size(400, 260), Title = "ドーナツグラフ", DataSource = new WorksheetChartDataSource(worksheet // ワークシートインスタンス , titleRange // データ系列名の範囲 , dataRange // データ範囲 , RowOrColumn.Column // データ範囲から系列を作成する方向(Row=行、Column=列) ), }; worksheet.FloatingObjects.Add(c1); }