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.PieOfPie, 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, -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.ISeries series1 = shape.Chart.SeriesCollection[0];
series1.HasDataLabels = true;
//config secondary section for pie of pie chart
shape.Chart.ChartGroups[0].SplitType = GrapeCity.Documents.Excel.Drawing.ChartSplitType.SplitByCustomSplit;
series1.Points[0].SecondaryPlot = true;
series1.Points[1].SecondaryPlot = false;
series1.Points[2].SecondaryPlot = true;
series1.Points[3].SecondaryPlot = false;
series1.Points[4].SecondaryPlot = true;
}
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:B13"].Value = new object[, ] {
{ "Blue Column", "Red Line" },
{ 75, 20 },
{ 149, 50 },
{ 105, 30 },
{ 55, 80 },
{ 121, 40 },
{ 76, 110 },
{ 128, 50 },
{ 114, 140 },
{ 75, 60 },
{ 105, 170 },
{ 145, 70 },
{ 110, 100 },
};
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:B13"], GrapeCity.Documents.Excel.Drawing.RowCol.Columns);
shape.Chart.ChartTitle.Text = "Combination Chart";
//change series type
GrapeCity.Documents.Excel.Drawing.ISeries series2 = shape.Chart.SeriesCollection[1];
series2.ChartType = GrapeCity.Documents.Excel.Drawing.ChartType.LineMarkers;
}
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, -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.ISeries series1 = shape.Chart.SeriesCollection[0];
series1.Trendlines.Add();
series1.Trendlines[0].Type = GrapeCity.Documents.Excel.Drawing.TrendlineType.Linear;
series1.Trendlines[0].Forward = 1;
series1.Trendlines[0].Backward = 0.5;
series1.Trendlines[0].Intercept = 2.5;
series1.Trendlines[0].DisplayEquation = true;
series1.Trendlines[0].DisplayRSquared = true;
}
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:B5"].Value = new object[, ]
{
{ null, "S1" },
{ "Item1", -20 },
{ "Item2", 30 },
{ "Item3", 50 },
{ "Item3", 40 }
};
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:B5"], GrapeCity.Documents.Excel.Drawing.RowCol.Columns, true, true);
GrapeCity.Documents.Excel.Drawing.ISeries series1 = shape.Chart.SeriesCollection[0];
series1.HasDataLabels = true;
series1.DataLabels.ShowSeriesName = true;
//set series1's all data label's format.
series1.DataLabels.Format.Fill.Color.RGB = Color.Pink;
series1.DataLabels.Format.Line.Color.RGB = Color.Green;
series1.DataLabels.Format.Line.Weight = 1;
//set series1's specific data label's format.
series1.DataLabels[2].Format.Fill.Color.RGB = Color.LightGreen;
series1.Points[2].DataLabel.Format.Line.Color.RGB = Color.Gray;
series1.Points[2].DataLabel.Format.Line.Weight = 2;
}
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.StockVHLC, 350, 20, 360, 230);
worksheet.Range["A1:E17"].Value = new object[, ] {
{ null, "Volume", "High", "Low", "Close" },
{ new DateTime(2019, 9, 1), 26085, 105.76, 92.38, 100.94 },
{ new DateTime(2019, 9, 2), 52314, 102.45, 90.14, 93.45 },
{ new DateTime(2019, 9, 3), 70308, 102.11, 85.01, 99.89 },
{ new DateTime(2019, 9, 4), 33401, 106.01, 94.04, 99.45 },
{ new DateTime(2019, 9, 5), 87500, 108.23, 98.16, 104.33 },
{ new DateTime(2019, 9, 8), 33756, 107.7, 91.02, 102.17 },
{ new DateTime(2019, 9, 9), 65737, 110.36, 101.62, 110.07 },
{ new DateTime(2019, 9, 10), 45668, 115.97, 106.89, 112.39 },
{ new DateTime(2019, 9, 11), 47815, 120.32, 112.15, 117.52 },
{ new DateTime(2019, 9, 12), 76759, 122.03, 114.67, 114.75 },
{ new DateTime(2019, 9, 15), 23492, 120.46, 106.21, 116.85 },
{ new DateTime(2019, 9, 16), 56127, 118.08, 113.55, 116.69 },
{ new DateTime(2019, 9, 17), 81142, 128.23, 110.91, 117.25 },
{ new DateTime(2019, 9, 18), 46384, 120.55, 108.09, 112.52 },
{ new DateTime(2019, 9, 19), 51005, 112.58, 105.42, 109.12 },
{ new DateTime(2019, 9, 22), 35223, 115.23, 97.25, 101.56 },
};
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:E17"], GrapeCity.Documents.Excel.Drawing.RowCol.Columns);
shape.Chart.ChartTitle.Text = "Volume-High-Low-Close Stock Chart";
shape.Chart.LineGroups[0].HiLoLines.Format.Line.Color.RGB = Color.Black;
GrapeCity.Documents.Excel.Drawing.IAxis valueAxis = shape.Chart.Axes.Item(GrapeCity.Documents.Excel.Drawing.AxisType.Value);
GrapeCity.Documents.Excel.Drawing.IAxis categoryAxis = shape.Chart.Axes.Item(GrapeCity.Documents.Excel.Drawing.AxisType.Category);
GrapeCity.Documents.Excel.Drawing.IAxis valueSecondaryAxis = shape.Chart.Axes.Item(GrapeCity.Documents.Excel.Drawing.AxisType.Value, GrapeCity.Documents.Excel.Drawing.AxisGroup.Secondary);
GrapeCity.Documents.Excel.Drawing.ISeries series_close = shape.Chart.SeriesCollection[3];
//config value axis
valueAxis.MinimumScale = 0;
valueAxis.MaximumScale = 150000;
valueAxis.MajorUnit = 30000;
//config category axis
categoryAxis.CategoryType = GrapeCity.Documents.Excel.Drawing.CategoryType.CategoryScale;
categoryAxis.MajorTickMark = GrapeCity.Documents.Excel.Drawing.TickMark.Outside;
categoryAxis.TickLabelSpacing = 4;
//config secondary value axis
valueSecondaryAxis.MinimumScale = 0;
valueSecondaryAxis.MaximumScale = 150;
valueSecondaryAxis.MajorUnit = 30;
//config marker style
series_close.MarkerFormat.Fill.Color.RGB = Color.Orange;
series_close.MarkerStyle = GrapeCity.Documents.Excel.Drawing.MarkerStyle.Square;
}
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, -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.ISeries series1 = shape.Chart.SeriesCollection[0];
//set series format.
series1.Format.Fill.Color.RGB = Color.MediumSeaGreen;
series1.Format.Line.Color.RGB = Color.Green;
series1.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:C6"].Value = new object[, ]
{
{ null, "S1", "S2" },
{ "Item1", 10, 25 },
{ "Item2", -51, -36 },
{ "Item3", 32, 64 },
{ "Item4", 44, 80 },
{ "Item5", 60, 100 }
};
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:D6"], GrapeCity.Documents.Excel.Drawing.RowCol.Columns, true, true);
GrapeCity.Documents.Excel.Drawing.ISeries series2 = shape.Chart.SeriesCollection[1];
//add a secondary axis
series2.AxisGroup = GrapeCity.Documents.Excel.Drawing.AxisGroup.Secondary;
series2.ChartType = GrapeCity.Documents.Excel.Drawing.ChartType.Line;
}
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.LineMarkers, 250, 20, 360, 230);
worksheet.Range["A1:B6"].Value = new object[, ]
{
{ null, "S1" },
{ "Item1", 10 },
{ "Item2", -51 },
{ "Item3", 52 },
{ "Item4", 22 },
{ "Item5", 40 }
};
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:B6"], GrapeCity.Documents.Excel.Drawing.RowCol.Columns, true, true);
GrapeCity.Documents.Excel.Drawing.ISeries series1 = shape.Chart.SeriesCollection[0];
//config line markers style
series1.MarkerStyle = GrapeCity.Documents.Excel.Drawing.MarkerStyle.Square;
series1.MarkerSize = 10;
}
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.StockHLC, 350, 20, 360, 230);
worksheet.Range["A1:D17"].Value = new object[, ] {
{ null, "High", "Low", "Close" },
{ new DateTime(2019, 9, 1), 105.76, 92.38, 100.94 },
{ new DateTime(2019, 9, 2), 102.45, 90.14, 93.45 },
{ new DateTime(2019, 9, 3), 102.11, 85.01, 99.89 },
{ new DateTime(2019, 9, 4), 106.01, 94.04, 99.45 },
{ new DateTime(2019, 9, 5), 108.23, 98.16, 104.33 },
{ new DateTime(2019, 9, 8), 107.7, 91.02, 102.17 },
{ new DateTime(2019, 9, 9), 110.36, 101.62, 110.07 },
{ new DateTime(2019, 9, 10), 115.97, 106.89, 112.39 },
{ new DateTime(2019, 9, 11), 120.32, 112.15, 117.52 },
{ new DateTime(2019, 9, 12), 122.03, 114.67, 114.75 },
{ new DateTime(2019, 9, 15), 120.46, 106.21, 116.85 },
{ new DateTime(2019, 9, 16), 118.08, 113.55, 116.69 },
{ new DateTime(2019, 9, 17), 128.23, 110.91, 117.25 },
{ new DateTime(2019, 9, 18), 120.55, 108.09, 112.52 },
{ new DateTime(2019, 9, 19), 112.58, 105.42, 109.12 },
{ new DateTime(2019, 9, 22), 115.23, 97.25, 101.56 },
};
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:D17"], GrapeCity.Documents.Excel.Drawing.RowCol.Columns);
shape.Chart.ChartTitle.Text = "High-Low-Close Stock Chart";
GrapeCity.Documents.Excel.Drawing.IAxis valueAxis = shape.Chart.Axes.Item(GrapeCity.Documents.Excel.Drawing.AxisType.Value);
GrapeCity.Documents.Excel.Drawing.IAxis categoryAxis = shape.Chart.Axes.Item(GrapeCity.Documents.Excel.Drawing.AxisType.Category);
GrapeCity.Documents.Excel.Drawing.ISeries series_close = shape.Chart.SeriesCollection[2];
//config value axis
valueAxis.MinimumScale = 80;
valueAxis.MaximumScale = 140;
valueAxis.MajorUnit = 15;
//config category axis
categoryAxis.CategoryType = Drawing.CategoryType.CategoryScale;
categoryAxis.MajorTickMark = Drawing.TickMark.Outside;
categoryAxis.TickLabelSpacingIsAuto = false;
categoryAxis.TickLabelSpacing = 5;
series_close.MarkerStyle = Drawing.MarkerStyle.Square;
}
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:B5"].Value = new object[, ]
{
{ null, "S1", "S2" },
{ "Item1", -20, 10 },
{ "Item2", 30, 60 },
{ "Item3", 50, 80 },
{ "Item3", 40, 70 }
};
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:B5"], GrapeCity.Documents.Excel.Drawing.RowCol.Columns, true, true);
GrapeCity.Documents.Excel.Drawing.ISeries series1 = shape.Chart.SeriesCollection[0];
series1.HasDataLabels = true;
//customize data lables' text.
series1.DataLabels.ShowCategoryName = true;
series1.DataLabels.ShowSeriesName = true;
series1.DataLabels.ShowLegendKey = true;
}
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:C17"].Value = new object[, ] {
{ "Area 1", "Column 1", "Column 2" },
{ 1350, 120, 75 },
{ 1500, 90, 35 },
{ 1200, 80, 50 },
{ 1300, 80, 80 },
{ 1750, 90, 100 },
{ 1640, 120, 130 },
{ 1700, 120, 95 },
{ 1100, 90, 80 },
{ 1350, 120, 75 },
{ 1500, 90, 35 },
{ 1200, 80, 50 },
};
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:C17"], GrapeCity.Documents.Excel.Drawing.RowCol.Columns);
shape.Chart.ChartTitle.Text = "Combination Chart";
GrapeCity.Documents.Excel.Drawing.ISeries series1 = shape.Chart.SeriesCollection[0];
GrapeCity.Documents.Excel.Drawing.ISeries series2 = shape.Chart.SeriesCollection[1];
GrapeCity.Documents.Excel.Drawing.ISeries series3 = shape.Chart.SeriesCollection[2];
//change series type
series1.ChartType = GrapeCity.Documents.Excel.Drawing.ChartType.Area;
series2.ChartType = GrapeCity.Documents.Excel.Drawing.ChartType.ColumnStacked;
series3.ChartType = GrapeCity.Documents.Excel.Drawing.ChartType.ColumnStacked;
//set axis group
series2.AxisGroup = GrapeCity.Documents.Excel.Drawing.AxisGroup.Secondary;
series3.AxisGroup = GrapeCity.Documents.Excel.Drawing.AxisGroup.Secondary;
//config axis sacle and unit
GrapeCity.Documents.Excel.Drawing.IAxis value_axis = shape.Chart.Axes.Item(GrapeCity.Documents.Excel.Drawing.AxisType.Value);
GrapeCity.Documents.Excel.Drawing.IAxis value_second_axis = shape.Chart.Axes.Item(GrapeCity.Documents.Excel.Drawing.AxisType.Value, GrapeCity.Documents.Excel.Drawing.AxisGroup.Secondary);
value_axis.MaximumScale = 1800;
value_axis.MajorUnit = 450;
value_second_axis.MaximumScale = 300;
value_second_axis.MajorUnit = 75;
}
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, -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.ISeries series1 = shape.Chart.SeriesCollection[0];
//if it is a negative point, it's color is red.
series1.InvertIfNegative = true;
series1.InvertColor.ObjectThemeColor = ThemeColor.Accent4;
}
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.LineMarkers, 250, 20, 360, 230);
worksheet.Range["A1:B6"].Value = new object[, ]
{
{ null, "S1" },
{ "Item1", 10 },
{ "Item2", -51 },
{ "Item3", 52 },
{ "Item4", 22 },
{ "Item5", 40 }
};
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:B6"], GrapeCity.Documents.Excel.Drawing.RowCol.Columns, true, true);
GrapeCity.Documents.Excel.Drawing.ISeries series1 = shape.Chart.SeriesCollection[0];
//config line markers style
series1.MarkerFormat.Fill.Color.RGB = Color.CornflowerBlue;
series1.MarkerFormat.Line.Style = GrapeCity.Documents.Excel.Drawing.LineStyle.ThickThin;
series1.MarkerFormat.Line.Color.RGB = Color.LightGreen;
series1.MarkerFormat.Line.Weight = 3;
}
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.Bubble, 250, 20, 350, 220);
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.ISeries series1 = shape.Chart.SeriesCollection[0];
series1.HasDataLabels = true;
shape.Chart.XYGroups[0].BubbleScale = 150;
shape.Chart.XYGroups[0].SizeRepresents = GrapeCity.Documents.Excel.Drawing.SizeRepresents.SizeIsArea;
shape.Chart.XYGroups[0].ShowNegativeBubbles = true;
}
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.XYScatter, 250, 20, 360, 230);
worksheet.Range["A1:D7"].Value = new object[, ] {
{ "Blue", null, "Red", null },
{ 55, 964, 67, 475 },
{ 20, 825, 10, 163 },
{ 77, 840, 87, 224 },
{ 182, 596, 46, 196 },
{ 190, 384, 100, 377 },
{ 140, 503, 92, 47 },
};
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:B7"], GrapeCity.Documents.Excel.Drawing.RowCol.Columns);
shape.Chart.SeriesCollection.Add(worksheet.Range["C1:D7"], GrapeCity.Documents.Excel.Drawing.RowCol.Columns);
shape.Chart.ChartTitle.Text = "Scatter Chart";
//config markers style
GrapeCity.Documents.Excel.Drawing.ISeries series1 = shape.Chart.SeriesCollection[0];
GrapeCity.Documents.Excel.Drawing.ISeries series2 = shape.Chart.SeriesCollection[1];
series1.MarkerStyle = Drawing.MarkerStyle.Square;
series1.MarkerSize = 10;
series2.MarkerSize = 10;
}
