internal void AddToChart(CT_LineChart ctLineChart) { CT_LineSer ctLineSer = ctLineChart.AddNewSer(); CT_Grouping ctGrouping = ctLineChart.AddNewGrouping(); ctGrouping.val = ST_Grouping.standard; ctLineSer.AddNewIdx().val = (uint)id; ctLineSer.AddNewOrder().val = (uint)order; // No marker symbol on the chart line. ctLineSer.AddNewMarker().AddNewSymbol().val = ST_MarkerStyle.none; CT_AxDataSource catDS = ctLineSer.AddNewCat(); XSSFChartUtil.BuildAxDataSource(catDS, categories); CT_NumDataSource valueDS = ctLineSer.AddNewVal(); XSSFChartUtil.BuildNumDataSource(valueDS, values); if (IsTitleSet) { ctLineSer.tx = GetCTSerTx(); } if (fillColor != null) { ctLineSer.spPr = new OpenXmlFormats.Dml.Chart.CT_ShapeProperties(); CT_LineProperties ctLineProperties = ctLineSer.spPr.AddNewLn(); CT_SolidColorFillProperties ctSolidColorFillProperties = ctLineProperties.AddNewSolidFill(); CT_SRgbColor ctSRgbColor = ctSolidColorFillProperties.AddNewSrgbClr(); ctSRgbColor.val = fillColor; } }
public void FillChart(SS.UserModel.IChart chart, params IChartAxis[] axis) { if (!(chart is XSSFChart)) { throw new ArgumentException("Chart must be instance of XSSFChart"); } XSSFChart xssfChart = (XSSFChart)chart; CT_PlotArea plotArea = xssfChart.GetCTChart().plotArea; int allSeriesCount = plotArea.GetAllSeriesCount(); CT_LineChart lineChart = plotArea.AddNewLineChart(); lineChart.AddNewVaryColors().val = 0; for (int i = 0; i < series.Count; ++i) { Series s = (Series)series[i]; s.SetId(allSeriesCount + i); s.SetOrder(allSeriesCount + i); s.AddToChart(lineChart); } foreach (IChartAxis ax in axis) { lineChart.AddNewAxId().val = (uint)ax.Id; } }
internal void AddToChart(CT_LineChart ctLineChart) { CT_LineSer ctLineSer = ctLineChart.AddNewSer(); ctLineSer.AddNewIdx().val = (uint)id; ctLineSer.AddNewOrder().val = (uint)order; // No marker symbol on the chart line. ctLineSer.AddNewMarker().AddNewSymbol().val = ST_MarkerStyle.none; CT_AxDataSource catDS = ctLineSer.AddNewCat(); XSSFChartUtil.BuildAxDataSource(catDS, categories); CT_NumDataSource valueDS = ctLineSer.AddNewVal(); XSSFChartUtil.BuildNumDataSource(valueDS, values); if (IsTitleSet) { ctLineSer.tx = GetCTSerTx(); } }
public void FillChart(SS.UserModel.IChart chart, params IChartAxis[] axis) { if (!(chart is XSSFChart)) { throw new ArgumentException("Chart must be instance of XSSFChart"); } XSSFChart xssfChart = (XSSFChart)chart; CT_PlotArea plotArea = xssfChart.GetCTChart().plotArea; CT_LineChart lineChart = plotArea.AddNewLineChart(); lineChart.AddNewVaryColors().val = 0; foreach (Serie s in series) { s.AddToChart(lineChart); } foreach (IChartAxis ax in axis) { lineChart.AddNewAxId().val = (uint)ax.GetId(); } }