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" },
{ 1, -25, 25, 25 },
{ 2, 51, 36, 27 },
{ 3, 52, 80, 30 },
{ 4, 22, -20, 65 },
{ 5, 23, 69, 69 }
};
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:D6"], GrapeCity.Documents.Excel.Drawing.RowCol.Columns, true, true);
GrapeCity.Documents.Excel.Drawing.IAxis category_axis = shape.Chart.Axes.Item(GrapeCity.Documents.Excel.Drawing.AxisType.Category);
GrapeCity.Documents.Excel.Drawing.IAxis value_axis = shape.Chart.Axes.Item(GrapeCity.Documents.Excel.Drawing.AxisType.Value);
//config tick label's format
category_axis.TickLabelPosition = GrapeCity.Documents.Excel.Drawing.TickLabelPosition.NextToAxis;
category_axis.TickLabelSpacing = 2;
category_axis.TickLabels.Font.Color.RGB = Color.DarkOrange;
category_axis.TickLabels.Font.Size = 12;
category_axis.TickLabels.NumberFormat = "#,##0.00";
value_axis.TickLabels.NumberFormat = "#,##0;[Red]#,##0";
}
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.IAxis value_axis = shape.Chart.Axes.Item(GrapeCity.Documents.Excel.Drawing.AxisType.Value);
value_axis.HasMajorGridlines = true;
value_axis.HasMinorGridlines = true;
value_axis.MajorGridlines.Format.Line.Color.RGB = Color.Gray;
value_axis.MajorGridlines.Format.Line.Weight = 1;
value_axis.MinorGridlines.Format.Line.Color.RGB = Color.LightGray;
value_axis.MinorGridlines.Format.Line.Weight = 0.75;
value_axis.MajorUnit = 40;
value_axis.MinorUnit = 8;
value_axis.MinorGridlines.Format.Line.Style = GrapeCity.Documents.Excel.Drawing.LineStyle.ThickThin;
}
public override void Execute(GrapeCity.Documents.Excel.Workbook workbook)
{
IWorksheet worksheet = workbook.Worksheets[0];
worksheet.Range["A2:A6"].NumberFormat = "m/d/yyyy";
worksheet.Range["A1:D6"].Value = new object[, ]
{
{ null, "S1", "S2", "S3" },
{ new DateTime(2015, 10, 7), 10, 25, 25 },
{ new DateTime(2015, 10, 24), 51, 36, 27 },
{ new DateTime(2015, 11, 8), 52, 85, 30 },
{ new DateTime(2015, 11, 25), 22, 65, 65 },
{ new DateTime(2015, 12, 10), 23, 69, 69 }
};
GrapeCity.Documents.Excel.Drawing.IShape shape = worksheet.Shapes.AddChart(GrapeCity.Documents.Excel.Drawing.ChartType.ColumnClustered, 250, 20, 360, 230);
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:D6"], GrapeCity.Documents.Excel.Drawing.RowCol.Columns, true, true);
GrapeCity.Documents.Excel.Drawing.IAxis category_axis = shape.Chart.Axes.Item(GrapeCity.Documents.Excel.Drawing.AxisType.Category);
category_axis.MaximumScale = new DateTime(2015, 12, 20).ToOADate();
category_axis.MinimumScale = new DateTime(2015, 10, 1).ToOADate();
category_axis.BaseUnit = GrapeCity.Documents.Excel.Drawing.TimeUnit.Months;
category_axis.MajorUnitScale = GrapeCity.Documents.Excel.Drawing.TimeUnit.Months;
category_axis.MajorUnit = 1;
category_axis.MinorUnitScale = GrapeCity.Documents.Excel.Drawing.TimeUnit.Days;
category_axis.MinorUnit = 15;
}
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.StockVOHLC, 300, 20, 360, 230);
worksheet.Range["A1:F23"].Value = new object[, ] {
{ null, "Volume", "Open", "High", "Low", "Close" },
{ new DateTime(2019, 9, 1), 26085, 103.46, 105.76, 92.38, 100.94 },
{ new DateTime(2019, 9, 2), 52314, 100.26, 102.45, 90.14, 93.45 },
{ new DateTime(2019, 9, 3), 70308, 98.05, 102.11, 85.01, 99.89 },
{ new DateTime(2019, 9, 4), 33401, 100.32, 106.01, 94.04, 99.45 },
{ new DateTime(2019, 9, 5), 87500, 99.74, 108.23, 98.16, 104.33 },
{ new DateTime(2019, 9, 8), 33756, 92.11, 107.7, 91.02, 102.17 },
{ new DateTime(2019, 9, 9), 65737, 107.8, 110.36, 101.62, 110.07 },
{ new DateTime(2019, 9, 10), 45668, 107.56, 115.97, 106.89, 112.39 },
{ new DateTime(2019, 9, 11), 47815, 112.86, 120.32, 112.15, 117.52 },
{ new DateTime(2019, 9, 12), 76759, 115.02, 122.03, 114.67, 114.75 },
{ new DateTime(2019, 9, 15), 23492, 108.53, 120.46, 106.21, 116.85 },
{ new DateTime(2019, 9, 16), 56127, 114.97, 118.08, 113.55, 116.69 },
{ new DateTime(2019, 9, 17), 81142, 127.14, 128.23, 110.91, 117.25 },
{ new DateTime(2019, 9, 18), 46384, 118.89, 120.55, 108.09, 112.52 },
{ new DateTime(2019, 9, 19), 51005, 105.57, 112.58, 105.42, 109.12 },
};
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:F23"], GrapeCity.Documents.Excel.Drawing.RowCol.Columns);
shape.Chart.ChartTitle.Text = "Stock Volume-Open-High-Low-Close 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.IAxis valueSecondaryAxis = shape.Chart.Axes.Item(GrapeCity.Documents.Excel.Drawing.AxisType.Value, GrapeCity.Documents.Excel.Drawing.AxisGroup.Secondary);
valueAxis.MinimumScale = 0;
valueAxis.MaximumScale = 150000;
valueAxis.MajorUnit = 30000;
categoryAxis.CategoryType = GrapeCity.Documents.Excel.Drawing.CategoryType.CategoryScale;
categoryAxis.TickLabelSpacing = 5;
valueSecondaryAxis.MajorUnit = 40;
}
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:D5"].Value = new object[, ]
{
{ null, "S1", "S2", "S3" },
{ "Item1", 4, 25, 7 },
{ "Item2", 15, -10, 18 },
{ "Item3", 45, 90, 20 },
{ "Item4", 8, 20, 11 },
};
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:D5"], GrapeCity.Documents.Excel.Drawing.RowCol.Columns, true, true);
GrapeCity.Documents.Excel.Drawing.IAxis value_axis = shape.Chart.Axes.Item(GrapeCity.Documents.Excel.Drawing.AxisType.Value);
value_axis.ScaleType = GrapeCity.Documents.Excel.Drawing.ScaleType.Logarithmic;
value_axis.LogBase = 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.StockOHLC, 350, 20, 360, 220);
worksheet.Range["A1:E17"].Value = new object[, ] {
{ null, "Open", "High", "Low", "Close" },
{ new DateTime(2019, 9, 1), 103.46, 105.76, 92.38, 100.94 },
{ new DateTime(2019, 9, 2), 100.26, 102.45, 90.14, 93.45 },
{ new DateTime(2019, 9, 3), 98.05, 102.11, 85.01, 99.89 },
{ new DateTime(2019, 9, 4), 100.32, 106.01, 94.04, 99.45 },
{ new DateTime(2019, 9, 5), 99.74, 108.23, 98.16, 104.33 },
{ new DateTime(2019, 9, 8), 92.11, 107.7, 91.02, 102.17 },
{ new DateTime(2019, 9, 9), 107.8, 110.36, 101.62, 110.07 },
{ new DateTime(2019, 9, 10), 107.56, 115.97, 106.89, 112.39 },
{ new DateTime(2019, 9, 11), 112.86, 120.32, 112.15, 117.52 },
{ new DateTime(2019, 9, 12), 115.02, 122.03, 114.67, 114.75 },
{ new DateTime(2019, 9, 15), 108.53, 120.46, 106.21, 116.85 },
{ new DateTime(2019, 9, 16), 114.97, 118.08, 113.55, 116.69 },
{ new DateTime(2019, 9, 17), 127.14, 128.23, 110.91, 117.25 },
{ new DateTime(2019, 9, 18), 118.89, 120.55, 108.09, 112.52 },
{ new DateTime(2019, 9, 19), 105.57, 112.58, 105.42, 109.12 },
{ new DateTime(2019, 9, 22), 110.23, 115.23, 97.25, 101.56 },
};
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:E17"], GrapeCity.Documents.Excel.Drawing.RowCol.Columns);
//set chart title
shape.Chart.ChartTitle.Text = "Open-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);
//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.TickMarkSpacing = 5;
categoryAxis.TickLabelSpacing = 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.Line, 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.IAxis value_axis = shape.Chart.Axes.Item(GrapeCity.Documents.Excel.Drawing.AxisType.Value);
//set value axis's format.
value_axis.Format.Line.Color.RGB = Color.FromRGB(91, 155, 213);
value_axis.Format.Line.Weight = 2;
value_axis.Format.Line.Style = GrapeCity.Documents.Excel.Drawing.LineStyle.Single;
}
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.Line, 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.IAxis category_axis = shape.Chart.Axes.Item(GrapeCity.Documents.Excel.Drawing.AxisType.Category);
category_axis.Format.Line.Color.RGB = Color.Green;
category_axis.Format.Line.Weight = 1.5;
category_axis.MajorTickMark = GrapeCity.Documents.Excel.Drawing.TickMark.Inside;
category_axis.MinorTickMark = GrapeCity.Documents.Excel.Drawing.TickMark.Cross;
category_axis.TickMarkSpacing = 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.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.IAxis category_axis = shape.Chart.Axes.Item(GrapeCity.Documents.Excel.Drawing.AxisType.Category);
//config axis title
category_axis.HasTitle = true;
category_axis.AxisTitle.Text = "CategoryAxisTitle";
category_axis.AxisTitle.Font.Size = 18;
category_axis.AxisTitle.Font.Color.RGB = Color.Orange;
}
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.IAxis value_axis = shape.Chart.Axes.Item(GrapeCity.Documents.Excel.Drawing.AxisType.Value);
value_axis.DisplayUnit = GrapeCity.Documents.Excel.Drawing.DisplayUnit.Custom;
value_axis.DisplayUnitCustom = 100;
value_axis.HasDisplayUnitLabel = true;
value_axis.DisplayUnitLabel.Font.Color.RGB = Color.CornflowerBlue;
value_axis.DisplayUnitLabel.Format.Fill.Color.RGB = Color.Orange;
value_axis.DisplayUnitLabel.Format.Line.Color.RGB = Color.CornflowerBlue;
}
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, 90, -30 },
{ "Item4", 22, 65, 50 },
{ "Item5", 23, 55, 69 }
};
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:D6"], GrapeCity.Documents.Excel.Drawing.RowCol.Columns, true, true);
GrapeCity.Documents.Excel.Drawing.IAxis category_axis = shape.Chart.Axes.Item(GrapeCity.Documents.Excel.Drawing.AxisType.Category);
GrapeCity.Documents.Excel.Drawing.IAxis value_axis = shape.Chart.Axes.Item(GrapeCity.Documents.Excel.Drawing.AxisType.Value);
value_axis.MaximumScale = 100;
value_axis.MinimumScale = -100;
value_axis.MajorUnit = 30;
value_axis.MinorUnit = 6;
}
