public override void Execute(GrapeCity.Documents.Excel.Workbook workbook) { IWorksheet worksheet = workbook.Worksheets[0]; GrapeCity.Documents.Excel.Drawing.IShape shape = worksheet.Shapes.AddChart(GrapeCity.Documents.Excel.Drawing.ChartType.Column3D, 250, 20, 350, 250); worksheet.Range["A1:D6"].Value = new object[, ] { { null, "S1", "S2", "S3" }, { "Item1", 10, 25, 25 }, { "Item2", -51, -36, 27 }, { "Item3", 52, -85, -30 }, { "Item4", 22, 65, 65 }, { "Item5", 23, 69, 69 } }; shape.Chart.SeriesCollection.Add(worksheet.Range["A1:D6"], GrapeCity.Documents.Excel.Drawing.RowCol.Columns, true, true); GrapeCity.Documents.Excel.Drawing.IChartArea chartarea = shape.Chart.ChartArea; //config 3D chart format chartarea.Format.ThreeD.RotationX = 60; chartarea.Format.ThreeD.RotationY = 60; }
public override void Execute(GrapeCity.Documents.Excel.Workbook workbook) { IWorksheet worksheet = workbook.Worksheets[0]; GrapeCity.Documents.Excel.Drawing.IShape shape = worksheet.Shapes.AddChart(GrapeCity.Documents.Excel.Drawing.ChartType.ColumnClustered, 250, 20, 360, 230); worksheet.Range["A1:D6"].Value = new object[, ] { { null, "S1", "S2", "S3" }, { "Item1", 10, 25, 25 }, { "Item2", -51, 36, 27 }, { "Item3", 52, 60, -30 }, { "Item4", 22, 65, 65 }, { "Item5", 23, 69, 69 } }; shape.Chart.SeriesCollection.Add(worksheet.Range["A1:D6"], GrapeCity.Documents.Excel.Drawing.RowCol.Columns, true, true); GrapeCity.Documents.Excel.Drawing.IChartArea chartarea = shape.Chart.ChartArea; //Format chartarea.Format.Fill.Color.RGB = Color.LightGray; chartarea.Format.Line.Color.RGB = Color.MediumSeaGreen; chartarea.Format.Line.Weight = 1.5; }
public override void Execute(GrapeCity.Documents.Excel.Workbook workbook) { IWorksheet worksheet = workbook.Worksheets[0]; GrapeCity.Documents.Excel.Drawing.IShape shape = worksheet.Shapes.AddChart(GrapeCity.Documents.Excel.Drawing.ChartType.ColumnClustered, 250, 20, 360, 230); worksheet.Range["A1:D6"].Value = new object[, ] { { null, "S1", "S2", "S3" }, { "Item1", 10, 25, 25 }, { "Item2", -51, 36, 27 }, { "Item3", 52, 60, -30 }, { "Item4", 22, 65, 65 }, { "Item5", 23, 69, 69 } }; shape.Chart.SeriesCollection.Add(worksheet.Range["A1:D6"], GrapeCity.Documents.Excel.Drawing.RowCol.Columns, true, true); GrapeCity.Documents.Excel.Drawing.IChartArea chartarea = shape.Chart.ChartArea; //Font chartarea.Font.Color.RGB = Color.MediumSeaGreen; chartarea.Font.Name = "Times New Roman"; chartarea.Font.Size = 12; //rounded corners. chartarea.RoundedCorners = true; }