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