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;
}
