private static ExcelStockChart AddStockChartStyle(ExcelWorksheet ws, eStockChartType type, eChartStyle style, string name, int row, int col, ExcelRange range, Action <ExcelStockChart> SetProperties) { var chart = AddStockChart(ws, type, name, row, col, range, SetProperties); chart.Style = style; return(chart); }
private static ExcelStockChart AddStockChart(ExcelWorksheet ws, eStockChartType type, string name, int row, int col, ExcelRange range, Action <ExcelStockChart> SetProperties) { var chart = ws.Drawings.AddStockChart(name, type, range); chart.SetPosition(row, 0, col, 0); chart.To.Column = col + 12; chart.To.ColumnOff = 0; chart.To.Row = row + 18; chart.To.RowOff = 0; SetProperties(chart); return(chart); }
private static void StockChartStyle(ExcelWorksheet ws, eStockChartType chartType, ExcelRange Range) { //Surface charts don't use chart styling in Excel, but styles can be applied anyway. //Stock chart Style 1 AddStockChartStyleManager(ws, chartType, ePresetChartStyle.StockChartStyle1, "StockChartStyle1", 0, 5, Range, c => { c.Legend.Position = eLegendPosition.Bottom; }); //Stock chart Style 2 AddStockChartStyleManager(ws, chartType, ePresetChartStyle.StockChartStyle2, "StockChartStyle2", 0, 18, Range, c => { c.Legend.Position = eLegendPosition.Bottom; }); //Stock chart Style 3 AddStockChartStyleManager(ws, chartType, ePresetChartStyle.StockChartStyle3, "StockChartStyle3", 0, 31, Range, c => { c.Legend.Position = eLegendPosition.Bottom; }); //Stock chart Style 4 AddStockChartStyleManager(ws, chartType, ePresetChartStyle.StockChartStyle4, "StockChartStyle4", 20, 5, Range, c => { c.Legend.Position = eLegendPosition.Bottom; }); //Stock chart Style 5 AddStockChartStyleManager(ws, chartType, ePresetChartStyle.StockChartStyle5, "StockChartStyle5", 20, 18, Range, c => { c.Legend.Position = eLegendPosition.Bottom; }); //Stock chart Style 6 AddStockChartStyleManager(ws, chartType, ePresetChartStyle.StockChartStyle6, "StockChartStyle6", 20, 31, Range, c => { c.Legend.Position = eLegendPosition.Bottom; }); //Stock chart Style 7 AddStockChartStyleManager(ws, chartType, ePresetChartStyle.StockChartStyle7, "StockChartStyle7", 40, 5, Range, c => { c.Legend.Position = eLegendPosition.Bottom; }); //Stock chart Style 8 AddStockChartStyleManager(ws, chartType, ePresetChartStyle.StockChartStyle8, "StockChartStyle8", 40, 18, Range, c => { c.Legend.Position = eLegendPosition.Bottom; }); //Stock chart Style 9 AddStockChartStyleManager(ws, chartType, ePresetChartStyle.StockChartStyle9, "StockChartStyle9", 40, 31, Range, c => { c.Legend.Position = eLegendPosition.Bottom; }); //Stock chart Style 10 AddStockChartStyleManager(ws, chartType, ePresetChartStyle.StockChartStyle10, "StockChartStyle10", 60, 5, Range, c => { c.Legend.Position = eLegendPosition.Bottom; }); //Stock chart Style 11 AddStockChartStyleManager(ws, chartType, ePresetChartStyle.StockChartStyle11, "StockChartStyle11", 60, 18, Range, c => { c.Legend.Position = eLegendPosition.Bottom; }); //Stock buildin chart 15 AddStockChartStyle(ws, chartType, eChartStyle.Style15, "StockChartStyle15", 80, 5, Range, c => { c.Legend.Position = eLegendPosition.Bottom; }); //Stock buildin chart 33 AddStockChartStyle(ws, chartType, eChartStyle.Style33, "StockChartStyle33", 80, 18, Range, c => { c.Legend.Position = eLegendPosition.Bottom; }); //Stock buildin chart 48 AddStockChartStyle(ws, chartType, eChartStyle.Style48, "StockChartStyle48", 80, 31, Range, c => { c.Legend.Position = eLegendPosition.Bottom; }); }