private static void StyleStackedBar3DChart(ExcelWorksheet ws, eBarChartType chartType) { //Style 1 AddBar(ws, chartType, "Column3DChartStyle1", 0, 5, ePresetChartStyle.StackedColumn3dChartStyle1, c => { c.Legend.Position = eLegendPosition.Bottom; c.Axis[0].MajorTickMark = eAxisTickMark.None; c.Axis[0].MinorTickMark = eAxisTickMark.None; c.Axis[1].MajorTickMark = eAxisTickMark.None; c.Axis[1].MinorTickMark = eAxisTickMark.None; }); //Style 2 var chart2 = AddBar(ws, chartType, "Column3DChartStyle2", 0, 18, ePresetChartStyle.StackedColumn3dChartStyle2, c => { c.Legend.Position = eLegendPosition.Top; }); //Style 3 var chart3 = AddBar(ws, chartType, "Column3DChartStyle3", 0, 31, ePresetChartStyle.StackedColumn3dChartStyle3, c => { c.DataLabel.ShowPercent = true; }); //Style 4 AddBar(ws, chartType, "Column3DChartStyle4", 22, 5, ePresetChartStyle.StackedColumn3dChartStyle4, c => { }); //Style 5 AddBar(ws, chartType, "Column3DChartStyle5", 22, 18, ePresetChartStyle.StackedColumn3dChartStyle5, c => { c.Legend.Position = eLegendPosition.Top; }); //Style 6 AddBar(ws, chartType, "Column3DChartStyle6", 22, 31, ePresetChartStyle.StackedColumn3dChartStyle6, c => { c.DataLabel.ShowPercent = true; }); //Style 7 AddBar(ws, chartType, "Column3DChartStyle7", 44, 5, ePresetChartStyle.StackedColumn3dChartStyle7, c => { }); //Style 8 AddBar(ws, chartType, "Column3DChartStyle8", 44, 18, ePresetChartStyle.StackedColumn3dChartStyle8, c => { c.Legend.Position = eLegendPosition.Top; }); }
private static ExcelBarChart AddBar(ExcelWorksheet ws, eBarChartType type, string name, int row, int col, ePresetChartStyle style, Action <ExcelBarChart> SetProperties) { var chart = ws.Drawings.AddBarChart(name, type); chart.SetPosition(row, 0, col, 0); chart.To.Column = col + 12; chart.To.ColumnOff = 0; chart.To.Row = row + 18; chart.To.RowOff = 0; var serie = chart.Series.Add("D2:D8", "A2:A8"); SetProperties(chart); chart.StyleManager.SetChartStyle(style); return(chart); }
private static void StyleBarChart(ExcelWorksheet ws, eBarChartType chartType) { //Style 1 AddBar(ws, chartType, "ColumnChartStyle1", 0, 5, ePresetChartStyle.BarChartStyle1, c => { c.Legend.Position = eLegendPosition.Bottom; c.Axis[0].MajorTickMark = eAxisTickMark.None; c.Axis[0].MinorTickMark = eAxisTickMark.None; c.Axis[1].MajorTickMark = eAxisTickMark.None; c.Axis[1].MinorTickMark = eAxisTickMark.None; c.GapWidth = 219; c.Overlap = -27; }); //Style 2 AddBar(ws, chartType, "ColumnChartStyle2", 0, 18, ePresetChartStyle.BarChartStyle2, c => { c.Legend.Position = eLegendPosition.Top; }); //Style 3 var chart3 = AddBar(ws, chartType, "ColumnChartStyle3", 0, 31, ePresetChartStyle.BarChartStyle3, c => { c.DataLabel.ShowPercent = true; c.DataLabel.Position = eLabelPosition.Center; }); //Style 4 AddBar(ws, chartType, "ColumnChartStyle4", 22, 5, ePresetChartStyle.BarChartStyle4, c => { c.Legend.Position = eLegendPosition.Bottom; }); //Style 5 AddBar(ws, chartType, "ColumnChartStyle5", 22, 18, ePresetChartStyle.BarChartStyle5, c => { c.Legend.Position = eLegendPosition.Bottom; }); //Style 6 AddBar(ws, chartType, "ColumnChartStyle6", 22, 31, ePresetChartStyle.BarChartStyle6, c => { }); //Style 7 AddBar(ws, chartType, "ColumnChartStyle7", 44, 5, ePresetChartStyle.BarChartStyle7, c => { c.Legend.Position = eLegendPosition.Bottom; }); //Style 8 AddBar(ws, chartType, "ColumnChartStyle8", 44, 18, ePresetChartStyle.BarChartStyle8, c => { c.Legend.Position = eLegendPosition.Bottom; }); //Style 9 AddBar(ws, chartType, "ColumnChartStyle9", 44, 31, ePresetChartStyle.BarChartStyle9, c => { }); //Style 10 AddBar(ws, chartType, "ColumnChartStyle10", 66, 5, ePresetChartStyle.BarChartStyle10, c => { c.Legend.Position = eLegendPosition.Bottom; }); //Style 11 AddBar(ws, chartType, "ColumnChartStyle11", 66, 18, ePresetChartStyle.BarChartStyle11, c => { c.Legend.Position = eLegendPosition.Bottom; }); //Style 12 AddBar(ws, chartType, "ColumnChartStyle12", 66, 31, ePresetChartStyle.BarChartStyle12, c => { }); //Style 13 AddBar(ws, chartType, "ColumnChartStyle13", 88, 5, ePresetChartStyle.BarChartStyle13, c => { c.Legend.Position = eLegendPosition.Bottom; }); }
/// <summary> /// Adds a new barchart to the worksheet. /// </summary> /// <param name="Name"></param> /// <param name="ChartType">Type of linechart</param> /// <returns>The chart</returns> public ExcelBarChart AddBarChart(string Name, eBarChartType ChartType) { return((ExcelBarChart)AddChart(Name, (eChartType)ChartType, null)); }
/// <summary> /// Adds a new bar chart to the chart /// </summary> /// <param name="chartType">The type of the new chart</param> /// <returns>The chart</returns> public ExcelBarChart AddBarChart(eBarChartType chartType) { return((ExcelBarChart)Add((eChartType)chartType)); }