internal C.PlotArea ToPlotArea() { C.PlotArea pa = new C.PlotArea(); pa.Append(this.Layout.ToLayout()); int iChartType; int i; // TODO: the rendering order is sort of listed in the following. // But apparently if you plot data series for doughnut first before bar-of-pie // it's different than if you plot bar-of-pie then doughnut. // Find out the "correct" order next version I suppose... // Excel 2010 apparently sets this by default for any chart... SLGroupDataLabelOptions gdlo = new SLGroupDataLabelOptions(this.ShapeProperties.listThemeColors); gdlo.ShowLegendKey = false; gdlo.ShowValue = false; gdlo.ShowCategoryName = false; gdlo.ShowSeriesName = false; gdlo.ShowPercentage = false; gdlo.ShowBubbleSize = false; #region Doughnut iChartType = (int)SLDataSeriesChartType.DoughnutChart; if (this.UsedChartTypes[iChartType]) { C.DoughnutChart dc = new C.DoughnutChart(); dc.VaryColors = new C.VaryColors() { Val = this.UsedChartOptions[iChartType].VaryColors ?? true }; for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { dc.Append(this.DataSeries[i].ToPieChartSeries()); } } dc.Append(gdlo.ToDataLabels(new Dictionary<int, SLDataLabelOptions>(), false)); dc.Append(new C.FirstSliceAngle() { Val = this.UsedChartOptions[iChartType].FirstSliceAngle }); dc.Append(new C.HoleSize() { Val = this.UsedChartOptions[iChartType].HoleSize }); pa.Append(dc); } #endregion #region Bar-of-pie iChartType = (int)SLDataSeriesChartType.OfPieChartBar; if (this.UsedChartTypes[iChartType]) { C.OfPieChart opc = new C.OfPieChart(); opc.OfPieType = new C.OfPieType() { Val = C.OfPieValues.Bar }; opc.VaryColors = new C.VaryColors() { Val = this.UsedChartOptions[iChartType].VaryColors ?? true }; for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { opc.Append(this.DataSeries[i].ToPieChartSeries()); } } opc.Append(gdlo.ToDataLabels(new Dictionary<int, SLDataLabelOptions>(), false)); opc.Append(new C.GapWidth() { Val = this.UsedChartOptions[iChartType].GapWidth }); if (this.UsedChartOptions[iChartType].HasSplit) { opc.Append(new C.SplitType() { Val = this.UsedChartOptions[iChartType].SplitType }); if (this.UsedChartOptions[iChartType].SplitType != C.SplitValues.Custom) { opc.Append(new C.SplitPosition() { Val = this.UsedChartOptions[iChartType].SplitPosition }); } else { C.CustomSplit custsplit = new C.CustomSplit(); foreach (int iPiePoint in this.UsedChartOptions[iChartType].SecondPiePoints) { custsplit.Append(new C.SecondPiePoint() { Val = (uint)iPiePoint }); } opc.Append(custsplit); } } opc.Append(new C.SecondPieSize() { Val = this.UsedChartOptions[iChartType].SecondPieSize }); if (this.UsedChartOptions[iChartType].SeriesLinesShapeProperties.HasShapeProperties) { opc.Append(new C.SeriesLines() { ChartShapeProperties = this.UsedChartOptions[iChartType].SeriesLinesShapeProperties.ToChartShapeProperties() }); } else { opc.Append(new C.SeriesLines()); } pa.Append(opc); } #endregion #region Pie-of-pie iChartType = (int)SLDataSeriesChartType.OfPieChartPie; if (this.UsedChartTypes[iChartType]) { C.OfPieChart opc = new C.OfPieChart(); opc.OfPieType = new C.OfPieType() { Val = C.OfPieValues.Pie }; opc.VaryColors = new C.VaryColors() { Val = this.UsedChartOptions[iChartType].VaryColors ?? true }; for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { opc.Append(this.DataSeries[i].ToPieChartSeries()); } } opc.Append(gdlo.ToDataLabels(new Dictionary<int, SLDataLabelOptions>(), false)); opc.Append(new C.GapWidth() { Val = this.UsedChartOptions[iChartType].GapWidth }); if (this.UsedChartOptions[iChartType].HasSplit) { opc.Append(new C.SplitType() { Val = this.UsedChartOptions[iChartType].SplitType }); if (this.UsedChartOptions[iChartType].SplitType != C.SplitValues.Custom) { opc.Append(new C.SplitPosition() { Val = this.UsedChartOptions[iChartType].SplitPosition }); } else { C.CustomSplit custsplit = new C.CustomSplit(); foreach (int iPiePoint in this.UsedChartOptions[iChartType].SecondPiePoints) { custsplit.Append(new C.SecondPiePoint() { Val = (uint)iPiePoint }); } opc.Append(custsplit); } } opc.Append(new C.SecondPieSize() { Val = this.UsedChartOptions[iChartType].SecondPieSize }); if (this.UsedChartOptions[iChartType].SeriesLinesShapeProperties.HasShapeProperties) { opc.Append(new C.SeriesLines() { ChartShapeProperties = this.UsedChartOptions[iChartType].SeriesLinesShapeProperties.ToChartShapeProperties() }); } else { opc.Append(new C.SeriesLines()); } pa.Append(opc); } #endregion #region Pie iChartType = (int)SLDataSeriesChartType.PieChart; if (this.UsedChartTypes[iChartType]) { C.PieChart pc = new C.PieChart(); pc.VaryColors = new C.VaryColors() { Val = this.UsedChartOptions[iChartType].VaryColors ?? true }; for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { pc.Append(this.DataSeries[i].ToPieChartSeries()); } } pc.Append(gdlo.ToDataLabels(new Dictionary<int, SLDataLabelOptions>(), false)); pc.Append(new C.FirstSliceAngle() { Val = this.UsedChartOptions[iChartType].FirstSliceAngle }); pa.Append(pc); } #endregion #region Radar primary iChartType = (int)SLDataSeriesChartType.RadarChartPrimary; if (this.UsedChartTypes[iChartType]) { C.RadarChart rc = new C.RadarChart(); rc.RadarStyle = new C.RadarStyle() { Val = this.UsedChartOptions[iChartType].RadarStyle }; rc.VaryColors = new C.VaryColors() { Val = false }; for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { rc.Append(this.DataSeries[i].ToRadarChartSeries()); } } rc.Append(gdlo.ToDataLabels(new Dictionary<int, SLDataLabelOptions>(), false)); rc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis1 }); rc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis2 }); pa.Append(rc); } #endregion #region Radar secondary iChartType = (int)SLDataSeriesChartType.RadarChartSecondary; if (this.UsedChartTypes[iChartType]) { C.RadarChart rc = new C.RadarChart(); rc.RadarStyle = new C.RadarStyle() { Val = this.UsedChartOptions[iChartType].RadarStyle }; rc.VaryColors = new C.VaryColors() { Val = false }; for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { rc.Append(this.DataSeries[i].ToRadarChartSeries()); } } rc.Append(gdlo.ToDataLabels(new Dictionary<int, SLDataLabelOptions>(), false)); rc.Append(new C.AxisId() { Val = SLConstants.SecondaryAxis1 }); rc.Append(new C.AxisId() { Val = SLConstants.SecondaryAxis2 }); pa.Append(rc); } #endregion #region Area primary iChartType = (int)SLDataSeriesChartType.AreaChartPrimary; if (this.UsedChartTypes[iChartType]) { C.AreaChart ac = new C.AreaChart(); ac.Grouping = new C.Grouping() { Val = this.UsedChartOptions[iChartType].Grouping }; ac.VaryColors = new C.VaryColors() { Val = false }; for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { ac.Append(this.DataSeries[i].ToAreaChartSeries()); } } ac.Append(gdlo.ToDataLabels(new Dictionary<int, SLDataLabelOptions>(), false)); ac.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis1 }); ac.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis2 }); pa.Append(ac); } #endregion #region Area secondary iChartType = (int)SLDataSeriesChartType.AreaChartSecondary; if (this.UsedChartTypes[iChartType]) { C.AreaChart ac = new C.AreaChart(); ac.Grouping = new C.Grouping() { Val = this.UsedChartOptions[iChartType].Grouping }; ac.VaryColors = new C.VaryColors() { Val = false }; for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { ac.Append(this.DataSeries[i].ToAreaChartSeries()); } } ac.Append(gdlo.ToDataLabels(new Dictionary<int, SLDataLabelOptions>(), false)); ac.Append(new C.AxisId() { Val = SLConstants.SecondaryAxis1 }); ac.Append(new C.AxisId() { Val = SLConstants.SecondaryAxis2 }); pa.Append(ac); } #endregion #region Column primary iChartType = (int)SLDataSeriesChartType.BarChartColumnPrimary; if (this.UsedChartTypes[iChartType]) { C.BarChart bc = new C.BarChart(); bc.BarDirection = new C.BarDirection() { Val = C.BarDirectionValues.Column }; bc.BarGrouping = new C.BarGrouping() { Val = this.UsedChartOptions[iChartType].BarGrouping }; bc.VaryColors = new C.VaryColors() { Val = false }; for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { bc.Append(this.DataSeries[i].ToBarChartSeries()); } } bc.Append(gdlo.ToDataLabels(new Dictionary<int, SLDataLabelOptions>(), false)); bc.Append(new C.GapWidth() { Val = this.UsedChartOptions[iChartType].GapWidth }); if (this.UsedChartOptions[iChartType].Overlap != 0) { bc.Append(new C.Overlap() { Val = this.UsedChartOptions[iChartType].Overlap }); } bc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis1 }); bc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis2 }); pa.Append(bc); } #endregion #region Column secondary iChartType = (int)SLDataSeriesChartType.BarChartColumnSecondary; if (this.UsedChartTypes[iChartType]) { C.BarChart bc = new C.BarChart(); bc.BarDirection = new C.BarDirection() { Val = C.BarDirectionValues.Column }; bc.BarGrouping = new C.BarGrouping() { Val = this.UsedChartOptions[iChartType].BarGrouping }; bc.VaryColors = new C.VaryColors() { Val = false }; for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { bc.Append(this.DataSeries[i].ToBarChartSeries()); } } bc.Append(gdlo.ToDataLabels(new Dictionary<int, SLDataLabelOptions>(), false)); bc.Append(new C.GapWidth() { Val = this.UsedChartOptions[iChartType].GapWidth }); if (this.UsedChartOptions[iChartType].Overlap != 0) { bc.Append(new C.Overlap() { Val = this.UsedChartOptions[iChartType].Overlap }); } bc.Append(new C.AxisId() { Val = SLConstants.SecondaryAxis1 }); bc.Append(new C.AxisId() { Val = SLConstants.SecondaryAxis2 }); pa.Append(bc); } #endregion #region Bar primary iChartType = (int)SLDataSeriesChartType.BarChartBarPrimary; if (this.UsedChartTypes[iChartType]) { C.BarChart bc = new C.BarChart(); bc.BarDirection = new C.BarDirection() { Val = C.BarDirectionValues.Bar }; bc.BarGrouping = new C.BarGrouping() { Val = this.UsedChartOptions[iChartType].BarGrouping }; bc.VaryColors = new C.VaryColors() { Val = false }; for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { bc.Append(this.DataSeries[i].ToBarChartSeries()); } } bc.Append(gdlo.ToDataLabels(new Dictionary<int, SLDataLabelOptions>(), false)); bc.Append(new C.GapWidth() { Val = this.UsedChartOptions[iChartType].GapWidth }); if (this.UsedChartOptions[iChartType].Overlap != 0) { bc.Append(new C.Overlap() { Val = this.UsedChartOptions[iChartType].Overlap }); } bc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis1 }); bc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis2 }); pa.Append(bc); } #endregion #region Bar secondary iChartType = (int)SLDataSeriesChartType.BarChartBarSecondary; if (this.UsedChartTypes[iChartType]) { C.BarChart bc = new C.BarChart(); bc.BarDirection = new C.BarDirection() { Val = C.BarDirectionValues.Bar }; bc.BarGrouping = new C.BarGrouping() { Val = this.UsedChartOptions[iChartType].BarGrouping }; bc.VaryColors = new C.VaryColors() { Val = false }; for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { bc.Append(this.DataSeries[i].ToBarChartSeries()); } } bc.Append(gdlo.ToDataLabels(new Dictionary<int, SLDataLabelOptions>(), false)); bc.Append(new C.GapWidth() { Val = this.UsedChartOptions[iChartType].GapWidth }); if (this.UsedChartOptions[iChartType].Overlap != 0) { bc.Append(new C.Overlap() { Val = this.UsedChartOptions[iChartType].Overlap }); } bc.Append(new C.AxisId() { Val = SLConstants.SecondaryAxis1 }); bc.Append(new C.AxisId() { Val = SLConstants.SecondaryAxis2 }); pa.Append(bc); } #endregion #region Scatter primary iChartType = (int)SLDataSeriesChartType.ScatterChartPrimary; if (this.UsedChartTypes[iChartType]) { C.ScatterChart sc = new C.ScatterChart(); sc.ScatterStyle = new C.ScatterStyle() { Val = this.UsedChartOptions[iChartType].ScatterStyle }; sc.VaryColors = new C.VaryColors() { Val = false }; for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { sc.Append(this.DataSeries[i].ToScatterChartSeries()); } } sc.Append(gdlo.ToDataLabels(new Dictionary<int, SLDataLabelOptions>(), false)); sc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis1 }); sc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis2 }); pa.Append(sc); } #endregion #region Scatter secondary iChartType = (int)SLDataSeriesChartType.ScatterChartSecondary; if (this.UsedChartTypes[iChartType]) { C.ScatterChart sc = new C.ScatterChart(); sc.ScatterStyle = new C.ScatterStyle() { Val = this.UsedChartOptions[iChartType].ScatterStyle }; sc.VaryColors = new C.VaryColors() { Val = false }; for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { sc.Append(this.DataSeries[i].ToScatterChartSeries()); } } sc.Append(gdlo.ToDataLabels(new Dictionary<int, SLDataLabelOptions>(), false)); sc.Append(new C.AxisId() { Val = SLConstants.SecondaryAxis1 }); sc.Append(new C.AxisId() { Val = SLConstants.SecondaryAxis2 }); pa.Append(sc); } #endregion #region Line primary iChartType = (int)SLDataSeriesChartType.LineChartPrimary; if (this.UsedChartTypes[iChartType]) { C.LineChart lc = new C.LineChart(); lc.Grouping = new C.Grouping() { Val = this.UsedChartOptions[iChartType].Grouping }; lc.VaryColors = new C.VaryColors() { Val = false }; for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { lc.Append(this.DataSeries[i].ToLineChartSeries()); } } lc.Append(gdlo.ToDataLabels(new Dictionary<int, SLDataLabelOptions>(), false)); lc.Append(new C.ShowMarker() { Val = this.UsedChartOptions[iChartType].ShowMarker }); lc.Append(new C.Smooth() { Val = this.UsedChartOptions[iChartType].Smooth }); lc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis1 }); lc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis2 }); pa.Append(lc); } #endregion #region Line secondary iChartType = (int)SLDataSeriesChartType.LineChartSecondary; if (this.UsedChartTypes[iChartType]) { C.LineChart lc = new C.LineChart(); lc.Grouping = new C.Grouping() { Val = this.UsedChartOptions[iChartType].Grouping }; lc.VaryColors = new C.VaryColors() { Val = false }; for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { lc.Append(this.DataSeries[i].ToLineChartSeries()); } } lc.Append(gdlo.ToDataLabels(new Dictionary<int, SLDataLabelOptions>(), false)); lc.Append(new C.ShowMarker() { Val = this.UsedChartOptions[iChartType].ShowMarker }); lc.Append(new C.Smooth() { Val = this.UsedChartOptions[iChartType].Smooth }); lc.Append(new C.AxisId() { Val = SLConstants.SecondaryAxis1 }); lc.Append(new C.AxisId() { Val = SLConstants.SecondaryAxis2 }); pa.Append(lc); } #endregion #region Area3D iChartType = (int)SLDataSeriesChartType.Area3DChart; if (this.UsedChartTypes[iChartType]) { C.Area3DChart ac = new C.Area3DChart(); ac.Grouping = new C.Grouping() { Val = this.UsedChartOptions[iChartType].Grouping }; ac.VaryColors = new C.VaryColors() { Val = false }; for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { ac.Append(this.DataSeries[i].ToAreaChartSeries()); } } ac.Append(gdlo.ToDataLabels(new Dictionary<int, SLDataLabelOptions>(), false)); if (this.UsedChartOptions[iChartType].GapDepth != 150) { ac.Append(new C.GapDepth() { Val = this.UsedChartOptions[iChartType].GapDepth }); } ac.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis1 }); ac.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis2 }); ac.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis3 }); pa.Append(ac); } #endregion #region Bar3D iChartType = (int)SLDataSeriesChartType.Bar3DChart; if (this.UsedChartTypes[iChartType]) { C.Bar3DChart bc = new C.Bar3DChart(); bc.BarDirection = new C.BarDirection() { Val = this.UsedChartOptions[iChartType].BarDirection }; bc.BarGrouping = new C.BarGrouping() { Val = this.UsedChartOptions[iChartType].BarGrouping }; bc.VaryColors = new C.VaryColors() { Val = false }; for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { bc.Append(this.DataSeries[i].ToBarChartSeries()); } } bc.Append(gdlo.ToDataLabels(new Dictionary<int, SLDataLabelOptions>(), false)); bc.Append(new C.GapWidth() { Val = this.UsedChartOptions[iChartType].GapWidth }); if (this.UsedChartOptions[iChartType].GapDepth != 150) { bc.Append(new C.GapDepth() { Val = this.UsedChartOptions[iChartType].GapDepth }); } bc.Append(new C.Shape() { Val = this.UsedChartOptions[iChartType].Shape }); bc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis1 }); bc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis2 }); bc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis3 }); pa.Append(bc); } #endregion #region Bubble iChartType = (int)SLDataSeriesChartType.BubbleChart; if (this.UsedChartTypes[iChartType]) { C.BubbleChart bc = new C.BubbleChart(); bc.VaryColors = new C.VaryColors() { Val = false }; for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { bc.Append(this.DataSeries[i].ToBubbleChartSeries()); } } bc.Append(gdlo.ToDataLabels(new Dictionary<int, SLDataLabelOptions>(), false)); if (!this.UsedChartOptions[iChartType].Bubble3D) { bc.Append(new C.Bubble3D() { Val = this.UsedChartOptions[iChartType].Bubble3D }); } if (this.UsedChartOptions[iChartType].BubbleScale != 100) { bc.Append(new C.BubbleScale() { Val = this.UsedChartOptions[iChartType].BubbleScale }); } if (!this.UsedChartOptions[iChartType].ShowNegativeBubbles) { bc.Append(new C.ShowNegativeBubbles() { Val = this.UsedChartOptions[iChartType].ShowNegativeBubbles }); } if (this.UsedChartOptions[iChartType].SizeRepresents != C.SizeRepresentsValues.Area) { bc.Append(new C.SizeRepresents() { Val = this.UsedChartOptions[iChartType].SizeRepresents }); } bc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis1 }); bc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis2 }); pa.Append(bc); } #endregion #region Line3D iChartType = (int)SLDataSeriesChartType.Line3DChart; if (this.UsedChartTypes[iChartType]) { C.Line3DChart lc = new C.Line3DChart(); lc.Grouping = new C.Grouping() { Val = this.UsedChartOptions[iChartType].Grouping }; lc.VaryColors = new C.VaryColors() { Val = false }; for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { lc.Append(this.DataSeries[i].ToLineChartSeries()); } } lc.Append(gdlo.ToDataLabels(new Dictionary<int, SLDataLabelOptions>(), false)); if (this.UsedChartOptions[iChartType].GapDepth != 150) { lc.Append(new C.GapDepth() { Val = this.UsedChartOptions[iChartType].GapDepth }); } lc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis1 }); lc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis2 }); lc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis3 }); pa.Append(lc); } #endregion #region Pie3D iChartType = (int)SLDataSeriesChartType.Pie3DChart; if (this.UsedChartTypes[iChartType]) { C.Pie3DChart pc = new C.Pie3DChart(); pc.VaryColors = new C.VaryColors() { Val = this.UsedChartOptions[iChartType].VaryColors ?? true }; for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { pc.Append(this.DataSeries[i].ToPieChartSeries()); } } pc.Append(gdlo.ToDataLabels(new Dictionary<int, SLDataLabelOptions>(), false)); pa.Append(pc); } #endregion #region Surface iChartType = (int)SLDataSeriesChartType.SurfaceChart; if (this.UsedChartTypes[iChartType]) { C.SurfaceChart sc = new C.SurfaceChart(); if (this.UsedChartOptions[iChartType].bWireframe != null) { sc.Wireframe = new C.Wireframe() { Val = this.UsedChartOptions[iChartType].Wireframe }; } for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { sc.Append(this.DataSeries[i].ToSurfaceChartSeries()); } } sc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis1 }); sc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis2 }); sc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis3 }); pa.Append(sc); } #endregion #region Surface3D iChartType = (int)SLDataSeriesChartType.Surface3DChart; if (this.UsedChartTypes[iChartType]) { C.Surface3DChart sc = new C.Surface3DChart(); if (this.UsedChartOptions[iChartType].bWireframe != null) { sc.Wireframe = new C.Wireframe() { Val = this.UsedChartOptions[iChartType].Wireframe }; } for (i = 0; i < this.DataSeries.Count; ++i) { if ((int)this.DataSeries[i].ChartType == iChartType) { sc.Append(this.DataSeries[i].ToSurfaceChartSeries()); } } sc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis1 }); sc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis2 }); sc.Append(new C.AxisId() { Val = SLConstants.PrimaryAxis3 }); pa.Append(sc); } #endregion if (this.HasPrimaryAxes) { this.PrimaryTextAxis.IsCrosses = this.PrimaryValueAxis.OtherAxisIsCrosses; this.PrimaryTextAxis.Crosses = this.PrimaryValueAxis.OtherAxisCrosses; this.PrimaryTextAxis.CrossesAt = this.PrimaryValueAxis.OtherAxisCrossesAt; this.PrimaryTextAxis.OtherAxisIsInReverseOrder = this.PrimaryValueAxis.InReverseOrder; if (this.PrimaryValueAxis.OtherAxisIsCrosses != null && this.PrimaryValueAxis.OtherAxisIsCrosses.Value && this.PrimaryValueAxis.OtherAxisCrosses == C.CrossesValues.Maximum) { this.PrimaryTextAxis.OtherAxisCrossedAtMaximum = true; } else { this.PrimaryTextAxis.OtherAxisCrossedAtMaximum = false; } this.PrimaryValueAxis.IsCrosses = this.PrimaryTextAxis.OtherAxisIsCrosses; this.PrimaryValueAxis.Crosses = this.PrimaryTextAxis.OtherAxisCrosses; this.PrimaryValueAxis.CrossesAt = this.PrimaryTextAxis.OtherAxisCrossesAt; // value axis takes on text axis CrossBetween. this.PrimaryValueAxis.CrossBetween = this.PrimaryTextAxis.CrossBetween; this.PrimaryValueAxis.OtherAxisIsInReverseOrder = this.PrimaryTextAxis.InReverseOrder; if (this.PrimaryTextAxis.OtherAxisIsCrosses != null && this.PrimaryTextAxis.OtherAxisIsCrosses.Value && this.PrimaryTextAxis.OtherAxisCrosses == C.CrossesValues.Maximum) { this.PrimaryValueAxis.OtherAxisCrossedAtMaximum = true; } else { this.PrimaryValueAxis.OtherAxisCrossedAtMaximum = false; } switch (this.PrimaryTextAxis.AxisType) { case SLAxisType.Category: pa.Append(this.PrimaryTextAxis.ToCategoryAxis()); break; case SLAxisType.Date: pa.Append(this.PrimaryTextAxis.ToDateAxis()); break; case SLAxisType.Value: pa.Append(this.PrimaryTextAxis.ToValueAxis()); break; } pa.Append(this.PrimaryValueAxis.ToValueAxis()); } if (this.HasDepthAxis) { pa.Append(this.DepthAxis.ToSeriesAxis()); } if (this.HasSecondaryAxes) { this.SecondaryTextAxis.IsCrosses = this.SecondaryValueAxis.OtherAxisIsCrosses; this.SecondaryTextAxis.Crosses = this.SecondaryValueAxis.OtherAxisCrosses; this.SecondaryTextAxis.CrossesAt = this.SecondaryValueAxis.OtherAxisCrossesAt; this.SecondaryTextAxis.OtherAxisIsInReverseOrder = this.SecondaryValueAxis.InReverseOrder; if (this.SecondaryValueAxis.OtherAxisIsCrosses != null && this.SecondaryValueAxis.OtherAxisIsCrosses.Value && this.SecondaryValueAxis.OtherAxisCrosses == C.CrossesValues.Maximum) { this.SecondaryTextAxis.OtherAxisCrossedAtMaximum = true; } else { this.SecondaryTextAxis.OtherAxisCrossedAtMaximum = false; } this.SecondaryValueAxis.IsCrosses = this.SecondaryTextAxis.OtherAxisIsCrosses; this.SecondaryValueAxis.Crosses = this.SecondaryTextAxis.OtherAxisCrosses; this.SecondaryValueAxis.CrossesAt = this.SecondaryTextAxis.OtherAxisCrossesAt; // value axis takes on text axis CrossBetween. this.SecondaryValueAxis.CrossBetween = this.SecondaryTextAxis.CrossBetween; this.SecondaryValueAxis.OtherAxisIsInReverseOrder = this.SecondaryTextAxis.InReverseOrder; if (this.SecondaryTextAxis.OtherAxisIsCrosses != null && this.SecondaryTextAxis.OtherAxisIsCrosses.Value && this.SecondaryTextAxis.OtherAxisCrosses == C.CrossesValues.Maximum) { this.SecondaryValueAxis.OtherAxisCrossedAtMaximum = true; } else { this.SecondaryValueAxis.OtherAxisCrossedAtMaximum = false; } // the order of axes is: // 1) primary category/date/value axis // 2) primary value axis // 3) secondary value axis // 4) secondary category/date/value axis pa.Append(this.SecondaryValueAxis.ToValueAxis()); switch (this.SecondaryTextAxis.AxisType) { case SLAxisType.Category: pa.Append(this.SecondaryTextAxis.ToCategoryAxis()); break; case SLAxisType.Date: pa.Append(this.SecondaryTextAxis.ToDateAxis()); break; case SLAxisType.Value: pa.Append(this.SecondaryTextAxis.ToValueAxis()); break; } } if (this.ShowDataTable) pa.Append(this.DataTable.ToDataTable()); if (this.ShapeProperties.HasShapeProperties) pa.Append(this.ShapeProperties.ToChartShapeProperties()); return pa; }
// Generates content of chartPart1. private void GenerateChartPart1Content(ChartPart chartPart1, Chart chart) { C.ChartSpace chartSpace1 = new C.ChartSpace(); chartSpace1.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart"); chartSpace1.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main"); chartSpace1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); chartSpace1.AddNamespaceDeclaration("c16r2", "http://schemas.microsoft.com/office/drawing/2015/06/chart"); C.Date1904 date19041 = new C.Date1904() { Val = false }; C.EditingLanguage editingLanguage1 = new C.EditingLanguage() { Val = "en-US" }; C.RoundedCorners roundedCorners1 = new C.RoundedCorners() { Val = true }; AlternateContent alternateContent1 = new AlternateContent(); alternateContent1.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); AlternateContentChoice alternateContentChoice1 = new AlternateContentChoice() { Requires = "c14" }; alternateContentChoice1.AddNamespaceDeclaration("c14", "http://schemas.microsoft.com/office/drawing/2007/8/2/chart"); C14.Style style1 = new C14.Style() { Val = 110 }; alternateContentChoice1.Append(style1); AlternateContentFallback alternateContentFallback1 = new AlternateContentFallback(); C.Style style2 = new C.Style() { Val = 10 }; alternateContentFallback1.Append(style2); alternateContent1.Append(alternateContentChoice1); alternateContent1.Append(alternateContentFallback1); C.Chart chart1 = new C.Chart(); C.Title title1 = new C.Title(); C.ChartText chartText1 = new C.ChartText(); C.RichText richText1 = new C.RichText(); A.BodyProperties bodyProperties1 = new A.BodyProperties(); A.ListStyle listStyle1 = new A.ListStyle(); A.Paragraph paragraph1 = new A.Paragraph(); A.ParagraphProperties paragraphProperties1 = new A.ParagraphProperties(); A.DefaultRunProperties defaultRunProperties1 = new A.DefaultRunProperties(); paragraphProperties1.Append(defaultRunProperties1); A.Run run1 = new A.Run(); A.RunProperties runProperties1 = new A.RunProperties() { Language = "en-US", FontSize = 800 }; A.Text text1 = new A.Text(); text1.Text = ""; run1.Append(runProperties1); run1.Append(text1); A.Run run2 = new A.Run(); A.RunProperties runProperties2 = new A.RunProperties() { Language = "en-US", FontSize = 800, Baseline = 0 }; A.Text text2 = new A.Text(); text2.Text = chart.Title; run2.Append(runProperties2); run2.Append(text2); A.EndParagraphRunProperties endParagraphRunProperties1 = new A.EndParagraphRunProperties() { Language = "en-US", FontSize = 800 }; paragraph1.Append(paragraphProperties1); paragraph1.Append(run1); paragraph1.Append(run2); paragraph1.Append(endParagraphRunProperties1); richText1.Append(bodyProperties1); richText1.Append(listStyle1); richText1.Append(paragraph1); chartText1.Append(richText1); C.Layout layout1 = new C.Layout(); C.ManualLayout manualLayout1 = new C.ManualLayout(); C.LeftMode leftMode1 = new C.LeftMode() { Val = C.LayoutModeValues.Edge }; C.TopMode topMode1 = new C.TopMode() { Val = C.LayoutModeValues.Edge }; C.Left left1 = new C.Left() { Val = 0.14936699324798144D }; C.Top top1 = new C.Top() { Val = 7.5867300613079197E-2D }; manualLayout1.Append(leftMode1); manualLayout1.Append(topMode1); manualLayout1.Append(left1); manualLayout1.Append(top1); layout1.Append(manualLayout1); C.Overlay overlay1 = new C.Overlay() { Val = true }; title1.Append(chartText1); title1.Append(layout1); title1.Append(overlay1); C.AutoTitleDeleted autoTitleDeleted1 = new C.AutoTitleDeleted() { Val = false }; C.PlotArea plotArea1 = new C.PlotArea(); C.Layout layout2 = new C.Layout(); C.ManualLayout manualLayout2 = new C.ManualLayout(); C.LayoutTarget layoutTarget1 = new C.LayoutTarget() { Val = C.LayoutTargetValues.Inner }; C.LeftMode leftMode2 = new C.LeftMode() { Val = C.LayoutModeValues.Edge }; C.TopMode topMode2 = new C.TopMode() { Val = C.LayoutModeValues.Edge }; C.Left left2 = new C.Left() { Val = 0.10245464404093282D }; C.Top top2 = new C.Top() { Val = 4.7416814491091287E-2D }; C.Width width1 = new C.Width() { Val = 0.88919609910728359D }; C.Height height1 = new C.Height() { Val = 0.86D }; manualLayout2.Append(layoutTarget1); manualLayout2.Append(leftMode2); manualLayout2.Append(topMode2); manualLayout2.Append(left2); manualLayout2.Append(top2); manualLayout2.Append(width1); manualLayout2.Append(height1); layout2.Append(manualLayout2); C.AreaChart areaChart1 = new C.AreaChart(); C.Grouping grouping1 = new C.Grouping() { Val = C.GroupingValues.Standard }; C.VaryColors varyColors1 = new C.VaryColors() { Val = true }; C.AreaChartSeries areaChartSeries1 = new C.AreaChartSeries(); C.Index index1 = new C.Index() { Val = (UInt32Value)0U }; C.Order order1 = new C.Order() { Val = (UInt32Value)0U }; C.SeriesText seriesText1 = new C.SeriesText(); C.NumericValue numericValue1 = new C.NumericValue(); numericValue1.Text = chart.LegendTitle; seriesText1.Append(numericValue1); C.CategoryAxisData categoryAxisData1 = new C.CategoryAxisData(); C.NumberReference numberReference1 = new C.NumberReference(); C.NumRefExtensionList numRefExtensionList1 = new C.NumRefExtensionList(); C.NumRefExtension numRefExtension1 = new C.NumRefExtension() { Uri = "{02D57815-91ED-43cb-92C2-25804820EDAC}" }; numRefExtension1.AddNamespaceDeclaration("c15", "http://schemas.microsoft.com/office/drawing/2012/chart"); C15.FullReference fullReference1 = new C15.FullReference(); C15.SequenceOfReferences sequenceOfReferences1 = new C15.SequenceOfReferences(); sequenceOfReferences1.Text = chart.AxisX; fullReference1.Append(sequenceOfReferences1); numRefExtension1.Append(fullReference1); numRefExtensionList1.Append(numRefExtension1); C.Formula formula1 = new C.Formula(); formula1.Text = chart.AxisX; C.NumberingCache numberingCache1 = new C.NumberingCache(); C.FormatCode formatCode1 = new C.FormatCode(); formatCode1.Text = "General"; C.PointCount pointCount1 = new C.PointCount() { Val = (UInt32Value)(uint)chart.Labels.Count }; numberingCache1.Append(formatCode1); numberingCache1.Append(pointCount1); for (uint i = 0; i < chart.Labels.Count; i++) { C.NumericPoint numericPoint1 = new C.NumericPoint() { Index = (UInt32Value)i }; C.NumericValue numericValue2 = new C.NumericValue(); numericValue2.Text = chart.Labels[(int)i]; numericPoint1.Append(numericValue2); numberingCache1.Append(numericPoint1); } numberReference1.Append(numRefExtensionList1); numberReference1.Append(formula1); numberReference1.Append(numberingCache1); categoryAxisData1.Append(numberReference1); C.Values values1 = new C.Values(); C.NumberReference numberReference2 = new C.NumberReference(); C.NumRefExtensionList numRefExtensionList2 = new C.NumRefExtensionList(); C.NumRefExtension numRefExtension2 = new C.NumRefExtension() { Uri = "{02D57815-91ED-43cb-92C2-25804820EDAC}" }; numRefExtension2.AddNamespaceDeclaration("c15", "http://schemas.microsoft.com/office/drawing/2012/chart"); C15.FullReference fullReference2 = new C15.FullReference(); C15.SequenceOfReferences sequenceOfReferences2 = new C15.SequenceOfReferences(); sequenceOfReferences2.Text = chart.AxisY; fullReference2.Append(sequenceOfReferences2); numRefExtension2.Append(fullReference2); numRefExtensionList2.Append(numRefExtension2); C.Formula formula2 = new C.Formula(); formula2.Text = chart.AxisY; C.NumberingCache numberingCache2 = new C.NumberingCache(); C.FormatCode formatCode2 = new C.FormatCode(); formatCode2.Text = "0.00%"; C.PointCount pointCount2 = new C.PointCount() { Val = (UInt32Value)(uint)chart.Values.Count }; numberingCache2.Append(formatCode2); numberingCache2.Append(pointCount2); for (uint i = 0; i < chart.Values.Count; i++) { C.NumericPoint numericPoint27 = new C.NumericPoint() { Index = (UInt32Value)i }; C.NumericValue numericValue28 = new C.NumericValue(); numericValue28.Text = chart.Values[(int)i]; numericPoint27.Append(numericValue28); numberingCache2.Append(numericPoint27); } numberReference2.Append(numRefExtensionList2); numberReference2.Append(formula2); numberReference2.Append(numberingCache2); values1.Append(numberReference2); C.AreaSerExtensionList areaSerExtensionList1 = new C.AreaSerExtensionList(); C.AreaSerExtension areaSerExtension1 = new C.AreaSerExtension() { Uri = "{C3380CC4-5D6E-409C-BE32-E72D297353CC}" }; areaSerExtension1.AddNamespaceDeclaration("c16", "http://schemas.microsoft.com/office/drawing/2014/chart"); OpenXmlUnknownElement openXmlUnknownElement2 = OpenXmlUnknownElement.CreateOpenXmlUnknownElement("<c16:uniqueId val=\"{00000000-69FF-4CCD-9302-CEC5CC8046DF}\" xmlns:c16=\"http://schemas.microsoft.com/office/drawing/2014/chart\" />"); areaSerExtension1.Append(openXmlUnknownElement2); areaSerExtensionList1.Append(areaSerExtension1); areaChartSeries1.Append(index1); areaChartSeries1.Append(order1); areaChartSeries1.Append(seriesText1); areaChartSeries1.Append(categoryAxisData1); areaChartSeries1.Append(values1); areaChartSeries1.Append(areaSerExtensionList1); C.DataLabels dataLabels1 = new C.DataLabels(); C.ShowLegendKey showLegendKey1 = new C.ShowLegendKey() { Val = false }; C.ShowValue showValue1 = new C.ShowValue() { Val = false }; C.ShowCategoryName showCategoryName1 = new C.ShowCategoryName() { Val = false }; C.ShowSeriesName showSeriesName1 = new C.ShowSeriesName() { Val = false }; C.ShowPercent showPercent1 = new C.ShowPercent() { Val = false }; C.ShowBubbleSize showBubbleSize1 = new C.ShowBubbleSize() { Val = false }; dataLabels1.Append(showLegendKey1); dataLabels1.Append(showValue1); dataLabels1.Append(showCategoryName1); dataLabels1.Append(showSeriesName1); dataLabels1.Append(showPercent1); dataLabels1.Append(showBubbleSize1); C.AxisId axisId1 = new C.AxisId() { Val = (UInt32Value)78173696U }; C.AxisId axisId2 = new C.AxisId() { Val = (UInt32Value)78175232U }; areaChart1.Append(grouping1); areaChart1.Append(varyColors1); areaChart1.Append(areaChartSeries1); areaChart1.Append(dataLabels1); areaChart1.Append(axisId1); areaChart1.Append(axisId2); C.CategoryAxis categoryAxis1 = new C.CategoryAxis(); C.AxisId axisId3 = new C.AxisId() { Val = (UInt32Value)78173696U }; C.Scaling scaling1 = new C.Scaling(); C.Orientation orientation1 = new C.Orientation() { Val = C.OrientationValues.MinMax }; scaling1.Append(orientation1); C.Delete delete1 = new C.Delete() { Val = true }; C.AxisPosition axisPosition1 = new C.AxisPosition() { Val = C.AxisPositionValues.Bottom }; C.NumberingFormat numberingFormat1 = new C.NumberingFormat() { FormatCode = "General", SourceLinked = true }; C.MajorTickMark majorTickMark1 = new C.MajorTickMark() { Val = C.TickMarkValues.None }; C.MinorTickMark minorTickMark1 = new C.MinorTickMark() { Val = C.TickMarkValues.Cross }; C.TickLabelPosition tickLabelPosition1 = new C.TickLabelPosition() { Val = C.TickLabelPositionValues.NextTo }; C.CrossingAxis crossingAxis1 = new C.CrossingAxis() { Val = (UInt32Value)78175232U }; C.Crosses crosses1 = new C.Crosses() { Val = C.CrossesValues.AutoZero }; C.AutoLabeled autoLabeled1 = new C.AutoLabeled() { Val = true }; C.LabelAlignment labelAlignment1 = new C.LabelAlignment() { Val = C.LabelAlignmentValues.Center }; C.LabelOffset labelOffset1 = new C.LabelOffset() { Val = (UInt16Value)100U }; C.NoMultiLevelLabels noMultiLevelLabels1 = new C.NoMultiLevelLabels() { Val = true }; categoryAxis1.Append(axisId3); categoryAxis1.Append(scaling1); categoryAxis1.Append(delete1); categoryAxis1.Append(axisPosition1); categoryAxis1.Append(numberingFormat1); categoryAxis1.Append(majorTickMark1); categoryAxis1.Append(minorTickMark1); categoryAxis1.Append(tickLabelPosition1); categoryAxis1.Append(crossingAxis1); categoryAxis1.Append(crosses1); categoryAxis1.Append(autoLabeled1); categoryAxis1.Append(labelAlignment1); categoryAxis1.Append(labelOffset1); categoryAxis1.Append(noMultiLevelLabels1); C.ValueAxis valueAxis1 = new C.ValueAxis(); C.AxisId axisId4 = new C.AxisId() { Val = (UInt32Value)78175232U }; C.Scaling scaling2 = new C.Scaling(); C.Orientation orientation2 = new C.Orientation() { Val = C.OrientationValues.MinMax }; scaling2.Append(orientation2); C.Delete delete2 = new C.Delete() { Val = true }; C.AxisPosition axisPosition2 = new C.AxisPosition() { Val = C.AxisPositionValues.Left }; C.MajorGridlines majorGridlines1 = new C.MajorGridlines(); C.NumberingFormat numberingFormat2 = new C.NumberingFormat() { FormatCode = "General", SourceLinked = true }; C.MajorTickMark majorTickMark2 = new C.MajorTickMark() { Val = C.TickMarkValues.None }; C.MinorTickMark minorTickMark2 = new C.MinorTickMark() { Val = C.TickMarkValues.Cross }; C.TickLabelPosition tickLabelPosition2 = new C.TickLabelPosition() { Val = C.TickLabelPositionValues.NextTo }; C.CrossingAxis crossingAxis2 = new C.CrossingAxis() { Val = (UInt32Value)78173696U }; C.Crosses crosses2 = new C.Crosses() { Val = C.CrossesValues.AutoZero }; C.CrossBetween crossBetween1 = new C.CrossBetween() { Val = C.CrossBetweenValues.MidpointCategory }; valueAxis1.Append(axisId4); valueAxis1.Append(scaling2); valueAxis1.Append(delete2); valueAxis1.Append(axisPosition2); valueAxis1.Append(majorGridlines1); valueAxis1.Append(numberingFormat2); valueAxis1.Append(majorTickMark2); valueAxis1.Append(minorTickMark2); valueAxis1.Append(tickLabelPosition2); valueAxis1.Append(crossingAxis2); valueAxis1.Append(crosses2); valueAxis1.Append(crossBetween1); C.DataTable dataTable1 = new C.DataTable(); C.ShowHorizontalBorder showHorizontalBorder1 = new C.ShowHorizontalBorder() { Val = true }; C.ShowVerticalBorder showVerticalBorder1 = new C.ShowVerticalBorder() { Val = true }; C.ShowOutlineBorder showOutlineBorder1 = new C.ShowOutlineBorder() { Val = true }; C.ShowKeys showKeys1 = new C.ShowKeys() { Val = true }; dataTable1.Append(showHorizontalBorder1); dataTable1.Append(showVerticalBorder1); dataTable1.Append(showOutlineBorder1); dataTable1.Append(showKeys1); C.ShapeProperties shapeProperties1 = new C.ShapeProperties(); A.Outline outline1 = new A.Outline(); A.NoFill noFill1 = new A.NoFill(); outline1.Append(noFill1); shapeProperties1.Append(outline1); plotArea1.Append(layout2); plotArea1.Append(areaChart1); plotArea1.Append(categoryAxis1); plotArea1.Append(valueAxis1); plotArea1.Append(dataTable1); plotArea1.Append(shapeProperties1); C.PlotVisibleOnly plotVisibleOnly1 = new C.PlotVisibleOnly() { Val = true }; C.DisplayBlanksAs displayBlanksAs1 = new C.DisplayBlanksAs() { Val = C.DisplayBlanksAsValues.Zero }; C.ShowDataLabelsOverMaximum showDataLabelsOverMaximum1 = new C.ShowDataLabelsOverMaximum() { Val = true }; chart1.Append(title1); chart1.Append(autoTitleDeleted1); chart1.Append(plotArea1); chart1.Append(plotVisibleOnly1); chart1.Append(displayBlanksAs1); chart1.Append(showDataLabelsOverMaximum1); C.ShapeProperties shapeProperties2 = new C.ShapeProperties(); A.Outline outline2 = new A.Outline(); A.NoFill noFill2 = new A.NoFill(); outline2.Append(noFill2); shapeProperties2.Append(outline2); C.TextProperties textProperties1 = new C.TextProperties(); A.BodyProperties bodyProperties2 = new A.BodyProperties(); A.ListStyle listStyle2 = new A.ListStyle(); A.Paragraph paragraph2 = new A.Paragraph(); A.ParagraphProperties paragraphProperties2 = new A.ParagraphProperties(); A.DefaultRunProperties defaultRunProperties2 = new A.DefaultRunProperties() { FontSize = 700 }; paragraphProperties2.Append(defaultRunProperties2); A.EndParagraphRunProperties endParagraphRunProperties2 = new A.EndParagraphRunProperties() { Language = "en-US" }; paragraph2.Append(paragraphProperties2); paragraph2.Append(endParagraphRunProperties2); textProperties1.Append(bodyProperties2); textProperties1.Append(listStyle2); textProperties1.Append(paragraph2); C.PrintSettings printSettings1 = new C.PrintSettings(); C.HeaderFooter headerFooter1 = new C.HeaderFooter(); C.PageMargins pageMargins1 = new C.PageMargins() { Left = 0.70000000000000018D, Right = 0.70000000000000018D, Top = 0.75000000000000022D, Bottom = 0.75000000000000022D, Header = 0.3000000000000001D, Footer = 0.3000000000000001D }; C.PageSetup pageSetup1 = new C.PageSetup() { Orientation = C.PageSetupOrientationValues.Landscape }; printSettings1.Append(headerFooter1); printSettings1.Append(pageMargins1); printSettings1.Append(pageSetup1); chartSpace1.Append(date19041); chartSpace1.Append(editingLanguage1); chartSpace1.Append(roundedCorners1); chartSpace1.Append(alternateContent1); chartSpace1.Append(chart1); chartSpace1.Append(shapeProperties2); chartSpace1.Append(textProperties1); chartSpace1.Append(printSettings1); chartPart1.ChartSpace = chartSpace1; }
internal C.PlotArea ToPlotArea(bool IsStylish = false) { var pa = new C.PlotArea(); pa.Append(Layout.ToLayout()); int iChartType; int i; // TODO: the rendering order is sort of listed in the following. // But apparently if you plot data series for doughnut first before bar-of-pie // it's different than if you plot bar-of-pie then doughnut. // Find out the "correct" order next version I suppose... // Excel 2010 apparently sets this by default for any chart... var gdlo = new SLGroupDataLabelOptions(ShapeProperties.listThemeColors); gdlo.ShowLegendKey = false; gdlo.ShowValue = false; gdlo.ShowCategoryName = false; gdlo.ShowSeriesName = false; gdlo.ShowPercentage = false; gdlo.ShowBubbleSize = false; #region Doughnut iChartType = (int)SLDataSeriesChartType.DoughnutChart; if (UsedChartTypes[iChartType]) { var dc = new C.DoughnutChart(); dc.VaryColors = new C.VaryColors { Val = UsedChartOptions[iChartType].VaryColors ?? true }; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { dc.Append(DataSeries[i].ToPieChartSeries(IsStylish)); } } dc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false)); dc.Append(new C.FirstSliceAngle { Val = UsedChartOptions[iChartType].FirstSliceAngle }); dc.Append(new C.HoleSize { Val = UsedChartOptions[iChartType].HoleSize }); pa.Append(dc); } #endregion #region Bar-of-pie iChartType = (int)SLDataSeriesChartType.OfPieChartBar; if (UsedChartTypes[iChartType]) { var opc = new C.OfPieChart(); opc.OfPieType = new C.OfPieType { Val = C.OfPieValues.Bar }; opc.VaryColors = new C.VaryColors { Val = UsedChartOptions[iChartType].VaryColors ?? true }; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { opc.Append(DataSeries[i].ToPieChartSeries(IsStylish)); } } opc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false)); opc.Append(new C.GapWidth { Val = UsedChartOptions[iChartType].GapWidth }); if (UsedChartOptions[iChartType].HasSplit) { opc.Append(new C.SplitType { Val = UsedChartOptions[iChartType].SplitType }); if (UsedChartOptions[iChartType].SplitType != C.SplitValues.Custom) { opc.Append(new C.SplitPosition { Val = UsedChartOptions[iChartType].SplitPosition }); } else { var custsplit = new C.CustomSplit(); foreach (var iPiePoint in UsedChartOptions[iChartType].SecondPiePoints) { custsplit.Append(new C.SecondPiePoint { Val = (uint)iPiePoint }); } opc.Append(custsplit); } } opc.Append(new C.SecondPieSize { Val = UsedChartOptions[iChartType].SecondPieSize }); if (UsedChartOptions[iChartType].SeriesLinesShapeProperties.HasShapeProperties) { opc.Append(new C.SeriesLines { ChartShapeProperties = UsedChartOptions[iChartType].SeriesLinesShapeProperties.ToChartShapeProperties() }); } else { opc.Append(new C.SeriesLines()); } pa.Append(opc); } #endregion #region Pie-of-pie iChartType = (int)SLDataSeriesChartType.OfPieChartPie; if (UsedChartTypes[iChartType]) { var opc = new C.OfPieChart(); opc.OfPieType = new C.OfPieType { Val = C.OfPieValues.Pie }; opc.VaryColors = new C.VaryColors { Val = UsedChartOptions[iChartType].VaryColors ?? true }; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { opc.Append(DataSeries[i].ToPieChartSeries(IsStylish)); } } opc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false)); opc.Append(new C.GapWidth { Val = UsedChartOptions[iChartType].GapWidth }); if (UsedChartOptions[iChartType].HasSplit) { opc.Append(new C.SplitType { Val = UsedChartOptions[iChartType].SplitType }); if (UsedChartOptions[iChartType].SplitType != C.SplitValues.Custom) { opc.Append(new C.SplitPosition { Val = UsedChartOptions[iChartType].SplitPosition }); } else { var custsplit = new C.CustomSplit(); foreach (var iPiePoint in UsedChartOptions[iChartType].SecondPiePoints) { custsplit.Append(new C.SecondPiePoint { Val = (uint)iPiePoint }); } opc.Append(custsplit); } } opc.Append(new C.SecondPieSize { Val = UsedChartOptions[iChartType].SecondPieSize }); if (UsedChartOptions[iChartType].SeriesLinesShapeProperties.HasShapeProperties) { opc.Append(new C.SeriesLines { ChartShapeProperties = UsedChartOptions[iChartType].SeriesLinesShapeProperties.ToChartShapeProperties() }); } else { opc.Append(new C.SeriesLines()); } pa.Append(opc); } #endregion #region Pie iChartType = (int)SLDataSeriesChartType.PieChart; if (UsedChartTypes[iChartType]) { var pc = new C.PieChart(); pc.VaryColors = new C.VaryColors { Val = UsedChartOptions[iChartType].VaryColors ?? true }; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { pc.Append(DataSeries[i].ToPieChartSeries(IsStylish)); } } pc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false)); pc.Append(new C.FirstSliceAngle { Val = UsedChartOptions[iChartType].FirstSliceAngle }); pa.Append(pc); } #endregion #region Radar primary iChartType = (int)SLDataSeriesChartType.RadarChartPrimary; if (UsedChartTypes[iChartType]) { var rc = new C.RadarChart(); rc.RadarStyle = new C.RadarStyle { Val = UsedChartOptions[iChartType].RadarStyle }; rc.VaryColors = new C.VaryColors { Val = false }; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { rc.Append(DataSeries[i].ToRadarChartSeries(IsStylish)); } } rc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false)); rc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis1 }); rc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis2 }); pa.Append(rc); } #endregion #region Radar secondary iChartType = (int)SLDataSeriesChartType.RadarChartSecondary; if (UsedChartTypes[iChartType]) { var rc = new C.RadarChart(); rc.RadarStyle = new C.RadarStyle { Val = UsedChartOptions[iChartType].RadarStyle }; rc.VaryColors = new C.VaryColors { Val = false }; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { rc.Append(DataSeries[i].ToRadarChartSeries(IsStylish)); } } rc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false)); rc.Append(new C.AxisId { Val = SLConstants.SecondaryAxis1 }); rc.Append(new C.AxisId { Val = SLConstants.SecondaryAxis2 }); pa.Append(rc); } #endregion #region Area primary iChartType = (int)SLDataSeriesChartType.AreaChartPrimary; if (UsedChartTypes[iChartType]) { var ac = new C.AreaChart(); ac.Grouping = new C.Grouping { Val = UsedChartOptions[iChartType].Grouping }; ac.VaryColors = new C.VaryColors { Val = false }; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { ac.Append(DataSeries[i].ToAreaChartSeries(IsStylish)); } } ac.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false)); if (UsedChartOptions[iChartType].HasDropLines) { ac.Append(UsedChartOptions[iChartType].DropLines.ToDropLines(IsStylish)); } ac.Append(new C.AxisId { Val = SLConstants.PrimaryAxis1 }); ac.Append(new C.AxisId { Val = SLConstants.PrimaryAxis2 }); pa.Append(ac); } #endregion #region Area secondary iChartType = (int)SLDataSeriesChartType.AreaChartSecondary; if (UsedChartTypes[iChartType]) { var ac = new C.AreaChart(); ac.Grouping = new C.Grouping { Val = UsedChartOptions[iChartType].Grouping }; ac.VaryColors = new C.VaryColors { Val = false }; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { ac.Append(DataSeries[i].ToAreaChartSeries(IsStylish)); } } ac.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false)); if (UsedChartOptions[iChartType].HasDropLines) { ac.Append(UsedChartOptions[iChartType].DropLines.ToDropLines(IsStylish)); } ac.Append(new C.AxisId { Val = SLConstants.SecondaryAxis1 }); ac.Append(new C.AxisId { Val = SLConstants.SecondaryAxis2 }); pa.Append(ac); } #endregion #region Column primary iChartType = (int)SLDataSeriesChartType.BarChartColumnPrimary; if (UsedChartTypes[iChartType]) { var bc = new C.BarChart(); bc.BarDirection = new C.BarDirection { Val = C.BarDirectionValues.Column }; bc.BarGrouping = new C.BarGrouping { Val = UsedChartOptions[iChartType].BarGrouping }; bc.VaryColors = new C.VaryColors { Val = false }; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { bc.Append(DataSeries[i].ToBarChartSeries(IsStylish)); } } bc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false)); bc.Append(new C.GapWidth { Val = UsedChartOptions[iChartType].GapWidth }); if (UsedChartOptions[iChartType].Overlap != 0) { bc.Append(new C.Overlap { Val = UsedChartOptions[iChartType].Overlap }); } bc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis1 }); bc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis2 }); pa.Append(bc); } #endregion #region Column secondary iChartType = (int)SLDataSeriesChartType.BarChartColumnSecondary; if (UsedChartTypes[iChartType]) { var bc = new C.BarChart(); bc.BarDirection = new C.BarDirection { Val = C.BarDirectionValues.Column }; bc.BarGrouping = new C.BarGrouping { Val = UsedChartOptions[iChartType].BarGrouping }; bc.VaryColors = new C.VaryColors { Val = false }; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { bc.Append(DataSeries[i].ToBarChartSeries(IsStylish)); } } bc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false)); bc.Append(new C.GapWidth { Val = UsedChartOptions[iChartType].GapWidth }); if (UsedChartOptions[iChartType].Overlap != 0) { bc.Append(new C.Overlap { Val = UsedChartOptions[iChartType].Overlap }); } bc.Append(new C.AxisId { Val = SLConstants.SecondaryAxis1 }); bc.Append(new C.AxisId { Val = SLConstants.SecondaryAxis2 }); pa.Append(bc); } #endregion #region Bar primary iChartType = (int)SLDataSeriesChartType.BarChartBarPrimary; if (UsedChartTypes[iChartType]) { var bc = new C.BarChart(); bc.BarDirection = new C.BarDirection { Val = C.BarDirectionValues.Bar }; bc.BarGrouping = new C.BarGrouping { Val = UsedChartOptions[iChartType].BarGrouping }; bc.VaryColors = new C.VaryColors { Val = false }; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { bc.Append(DataSeries[i].ToBarChartSeries(IsStylish)); } } bc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false)); bc.Append(new C.GapWidth { Val = UsedChartOptions[iChartType].GapWidth }); if (UsedChartOptions[iChartType].Overlap != 0) { bc.Append(new C.Overlap { Val = UsedChartOptions[iChartType].Overlap }); } bc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis1 }); bc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis2 }); pa.Append(bc); } #endregion #region Bar secondary iChartType = (int)SLDataSeriesChartType.BarChartBarSecondary; if (UsedChartTypes[iChartType]) { var bc = new C.BarChart(); bc.BarDirection = new C.BarDirection { Val = C.BarDirectionValues.Bar }; bc.BarGrouping = new C.BarGrouping { Val = UsedChartOptions[iChartType].BarGrouping }; bc.VaryColors = new C.VaryColors { Val = false }; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { bc.Append(DataSeries[i].ToBarChartSeries(IsStylish)); } } bc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false)); bc.Append(new C.GapWidth { Val = UsedChartOptions[iChartType].GapWidth }); if (UsedChartOptions[iChartType].Overlap != 0) { bc.Append(new C.Overlap { Val = UsedChartOptions[iChartType].Overlap }); } bc.Append(new C.AxisId { Val = SLConstants.SecondaryAxis1 }); bc.Append(new C.AxisId { Val = SLConstants.SecondaryAxis2 }); pa.Append(bc); } #endregion #region Scatter primary iChartType = (int)SLDataSeriesChartType.ScatterChartPrimary; if (UsedChartTypes[iChartType]) { var sc = new C.ScatterChart(); sc.ScatterStyle = new C.ScatterStyle { Val = UsedChartOptions[iChartType].ScatterStyle }; sc.VaryColors = new C.VaryColors { Val = false }; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { sc.Append(DataSeries[i].ToScatterChartSeries(IsStylish)); } } sc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false)); sc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis1 }); sc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis2 }); pa.Append(sc); } #endregion #region Scatter secondary iChartType = (int)SLDataSeriesChartType.ScatterChartSecondary; if (UsedChartTypes[iChartType]) { var sc = new C.ScatterChart(); sc.ScatterStyle = new C.ScatterStyle { Val = UsedChartOptions[iChartType].ScatterStyle }; sc.VaryColors = new C.VaryColors { Val = false }; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { sc.Append(DataSeries[i].ToScatterChartSeries(IsStylish)); } } sc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false)); sc.Append(new C.AxisId { Val = SLConstants.SecondaryAxis1 }); sc.Append(new C.AxisId { Val = SLConstants.SecondaryAxis2 }); pa.Append(sc); } #endregion #region Line primary iChartType = (int)SLDataSeriesChartType.LineChartPrimary; if (UsedChartTypes[iChartType]) { var lc = new C.LineChart(); lc.Grouping = new C.Grouping { Val = UsedChartOptions[iChartType].Grouping }; lc.VaryColors = new C.VaryColors { Val = false }; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { lc.Append(DataSeries[i].ToLineChartSeries(IsStylish)); } } lc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false)); if (UsedChartOptions[iChartType].HasDropLines) { lc.Append(UsedChartOptions[iChartType].DropLines.ToDropLines(IsStylish)); } lc.Append(new C.ShowMarker { Val = UsedChartOptions[iChartType].ShowMarker }); lc.Append(new C.Smooth { Val = UsedChartOptions[iChartType].Smooth }); lc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis1 }); lc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis2 }); pa.Append(lc); } #endregion #region Line secondary iChartType = (int)SLDataSeriesChartType.LineChartSecondary; if (UsedChartTypes[iChartType]) { var lc = new C.LineChart(); lc.Grouping = new C.Grouping { Val = UsedChartOptions[iChartType].Grouping }; lc.VaryColors = new C.VaryColors { Val = false }; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { lc.Append(DataSeries[i].ToLineChartSeries(IsStylish)); } } lc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false)); if (UsedChartOptions[iChartType].HasDropLines) { lc.Append(UsedChartOptions[iChartType].DropLines.ToDropLines(IsStylish)); } lc.Append(new C.ShowMarker { Val = UsedChartOptions[iChartType].ShowMarker }); lc.Append(new C.Smooth { Val = UsedChartOptions[iChartType].Smooth }); lc.Append(new C.AxisId { Val = SLConstants.SecondaryAxis1 }); lc.Append(new C.AxisId { Val = SLConstants.SecondaryAxis2 }); pa.Append(lc); } #endregion #region Area3D iChartType = (int)SLDataSeriesChartType.Area3DChart; if (UsedChartTypes[iChartType]) { var ac = new C.Area3DChart(); ac.Grouping = new C.Grouping { Val = UsedChartOptions[iChartType].Grouping }; ac.VaryColors = new C.VaryColors { Val = false }; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { ac.Append(DataSeries[i].ToAreaChartSeries(IsStylish)); } } ac.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false)); if (UsedChartOptions[iChartType].GapDepth != 150) { ac.Append(new C.GapDepth { Val = UsedChartOptions[iChartType].GapDepth }); } ac.Append(new C.AxisId { Val = SLConstants.PrimaryAxis1 }); ac.Append(new C.AxisId { Val = SLConstants.PrimaryAxis2 }); ac.Append(new C.AxisId { Val = SLConstants.PrimaryAxis3 }); pa.Append(ac); } #endregion #region Bar3D iChartType = (int)SLDataSeriesChartType.Bar3DChart; if (UsedChartTypes[iChartType]) { var bc = new C.Bar3DChart(); bc.BarDirection = new C.BarDirection { Val = UsedChartOptions[iChartType].BarDirection }; bc.BarGrouping = new C.BarGrouping { Val = UsedChartOptions[iChartType].BarGrouping }; bc.VaryColors = new C.VaryColors { Val = false }; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { bc.Append(DataSeries[i].ToBarChartSeries(IsStylish)); } } bc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false)); bc.Append(new C.GapWidth { Val = UsedChartOptions[iChartType].GapWidth }); if (UsedChartOptions[iChartType].GapDepth != 150) { bc.Append(new C.GapDepth { Val = UsedChartOptions[iChartType].GapDepth }); } bc.Append(new C.Shape { Val = UsedChartOptions[iChartType].Shape }); bc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis1 }); bc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis2 }); bc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis3 }); pa.Append(bc); } #endregion #region Bubble iChartType = (int)SLDataSeriesChartType.BubbleChart; if (UsedChartTypes[iChartType]) { var bc = new C.BubbleChart(); bc.VaryColors = new C.VaryColors { Val = false }; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { bc.Append(DataSeries[i].ToBubbleChartSeries(IsStylish)); } } bc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false)); if (!UsedChartOptions[iChartType].Bubble3D) { bc.Append(new C.Bubble3D { Val = UsedChartOptions[iChartType].Bubble3D }); } if (UsedChartOptions[iChartType].BubbleScale != 100) { bc.Append(new C.BubbleScale { Val = UsedChartOptions[iChartType].BubbleScale }); } if (!UsedChartOptions[iChartType].ShowNegativeBubbles) { bc.Append(new C.ShowNegativeBubbles { Val = UsedChartOptions[iChartType].ShowNegativeBubbles }); } if (UsedChartOptions[iChartType].SizeRepresents != C.SizeRepresentsValues.Area) { bc.Append(new C.SizeRepresents { Val = UsedChartOptions[iChartType].SizeRepresents }); } bc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis1 }); bc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis2 }); pa.Append(bc); } #endregion #region Line3D iChartType = (int)SLDataSeriesChartType.Line3DChart; if (UsedChartTypes[iChartType]) { var lc = new C.Line3DChart(); lc.Grouping = new C.Grouping { Val = UsedChartOptions[iChartType].Grouping }; lc.VaryColors = new C.VaryColors { Val = false }; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { lc.Append(DataSeries[i].ToLineChartSeries(IsStylish)); } } lc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false)); if (UsedChartOptions[iChartType].HasDropLines) { lc.Append(UsedChartOptions[iChartType].DropLines.ToDropLines(IsStylish)); } if (UsedChartOptions[iChartType].GapDepth != 150) { lc.Append(new C.GapDepth { Val = UsedChartOptions[iChartType].GapDepth }); } lc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis1 }); lc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis2 }); lc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis3 }); pa.Append(lc); } #endregion #region Pie3D iChartType = (int)SLDataSeriesChartType.Pie3DChart; if (UsedChartTypes[iChartType]) { var pc = new C.Pie3DChart(); pc.VaryColors = new C.VaryColors { Val = UsedChartOptions[iChartType].VaryColors ?? true }; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { pc.Append(DataSeries[i].ToPieChartSeries(IsStylish)); } } pc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false)); pa.Append(pc); } #endregion #region Surface iChartType = (int)SLDataSeriesChartType.SurfaceChart; if (UsedChartTypes[iChartType]) { var sc = new C.SurfaceChart(); if (UsedChartOptions[iChartType].bWireframe != null) { sc.Wireframe = new C.Wireframe { Val = UsedChartOptions[iChartType].Wireframe } } ; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { sc.Append(DataSeries[i].ToSurfaceChartSeries(IsStylish)); } } sc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis1 }); sc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis2 }); sc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis3 }); pa.Append(sc); } #endregion #region Surface3D iChartType = (int)SLDataSeriesChartType.Surface3DChart; if (UsedChartTypes[iChartType]) { var sc = new C.Surface3DChart(); if (UsedChartOptions[iChartType].bWireframe != null) { sc.Wireframe = new C.Wireframe { Val = UsedChartOptions[iChartType].Wireframe } } ; for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { sc.Append(DataSeries[i].ToSurfaceChartSeries(IsStylish)); } } sc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis1 }); sc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis2 }); sc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis3 }); pa.Append(sc); } #endregion #region Stock iChartType = (int)SLDataSeriesChartType.StockChart; if (UsedChartTypes[iChartType]) { var sc = new C.StockChart(); for (i = 0; i < DataSeries.Count; ++i) { if ((int)DataSeries[i].ChartType == iChartType) { sc.Append(DataSeries[i].ToLineChartSeries(IsStylish)); } } sc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false)); if (UsedChartOptions[iChartType].HasDropLines) { sc.Append(UsedChartOptions[iChartType].DropLines.ToDropLines(IsStylish)); } if (UsedChartOptions[iChartType].HasHighLowLines) { sc.Append(UsedChartOptions[iChartType].HighLowLines.ToHighLowLines(IsStylish)); } if (UsedChartOptions[iChartType].HasUpDownBars) { sc.Append(UsedChartOptions[iChartType].UpDownBars.ToUpDownBars(IsStylish)); } // stock charts either have a bar chart as the primary chart (the Volume) or doesn't. // If there is, then it's either a Volume-High-Low-Close or Volumn-Open-High-Low-Close, // so we use the secondary axis IDs. if (UsedChartTypes[(int)SLDataSeriesChartType.BarChartColumnPrimary]) { sc.Append(new C.AxisId { Val = SLConstants.SecondaryAxis1 }); sc.Append(new C.AxisId { Val = SLConstants.SecondaryAxis2 }); } else { sc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis1 }); sc.Append(new C.AxisId { Val = SLConstants.PrimaryAxis2 }); } pa.Append(sc); } #endregion if (HasPrimaryAxes) { PrimaryTextAxis.IsCrosses = PrimaryValueAxis.OtherAxisIsCrosses; PrimaryTextAxis.Crosses = PrimaryValueAxis.OtherAxisCrosses; PrimaryTextAxis.CrossesAt = PrimaryValueAxis.OtherAxisCrossesAt; PrimaryTextAxis.OtherAxisIsInReverseOrder = PrimaryValueAxis.InReverseOrder; if ((PrimaryValueAxis.OtherAxisIsCrosses != null) && PrimaryValueAxis.OtherAxisIsCrosses.Value && (PrimaryValueAxis.OtherAxisCrosses == C.CrossesValues.Maximum)) { PrimaryTextAxis.OtherAxisCrossedAtMaximum = true; } else { PrimaryTextAxis.OtherAxisCrossedAtMaximum = false; } PrimaryValueAxis.IsCrosses = PrimaryTextAxis.OtherAxisIsCrosses; PrimaryValueAxis.Crosses = PrimaryTextAxis.OtherAxisCrosses; PrimaryValueAxis.CrossesAt = PrimaryTextAxis.OtherAxisCrossesAt; PrimaryValueAxis.OtherAxisIsInReverseOrder = PrimaryTextAxis.InReverseOrder; if ((PrimaryTextAxis.OtherAxisIsCrosses != null) && PrimaryTextAxis.OtherAxisIsCrosses.Value && (PrimaryTextAxis.OtherAxisCrosses == C.CrossesValues.Maximum)) { PrimaryValueAxis.OtherAxisCrossedAtMaximum = true; } else { PrimaryValueAxis.OtherAxisCrossedAtMaximum = false; } switch (PrimaryTextAxis.AxisType) { case SLAxisType.Category: pa.Append(PrimaryTextAxis.ToCategoryAxis(IsStylish)); break; case SLAxisType.Date: pa.Append(PrimaryTextAxis.ToDateAxis(IsStylish)); break; case SLAxisType.Value: pa.Append(PrimaryTextAxis.ToValueAxis(IsStylish)); break; } pa.Append(PrimaryValueAxis.ToValueAxis(IsStylish)); } if (HasDepthAxis) { pa.Append(DepthAxis.ToSeriesAxis(IsStylish)); } if (HasSecondaryAxes) { SecondaryTextAxis.IsCrosses = SecondaryValueAxis.OtherAxisIsCrosses; SecondaryTextAxis.Crosses = SecondaryValueAxis.OtherAxisCrosses; SecondaryTextAxis.CrossesAt = SecondaryValueAxis.OtherAxisCrossesAt; SecondaryTextAxis.OtherAxisIsInReverseOrder = SecondaryValueAxis.InReverseOrder; if ((SecondaryValueAxis.OtherAxisIsCrosses != null) && SecondaryValueAxis.OtherAxisIsCrosses.Value && (SecondaryValueAxis.OtherAxisCrosses == C.CrossesValues.Maximum)) { SecondaryTextAxis.OtherAxisCrossedAtMaximum = true; } else { SecondaryTextAxis.OtherAxisCrossedAtMaximum = false; } SecondaryValueAxis.IsCrosses = SecondaryTextAxis.OtherAxisIsCrosses; SecondaryValueAxis.Crosses = SecondaryTextAxis.OtherAxisCrosses; SecondaryValueAxis.CrossesAt = SecondaryTextAxis.OtherAxisCrossesAt; SecondaryValueAxis.OtherAxisIsInReverseOrder = SecondaryTextAxis.InReverseOrder; if ((SecondaryTextAxis.OtherAxisIsCrosses != null) && SecondaryTextAxis.OtherAxisIsCrosses.Value && (SecondaryTextAxis.OtherAxisCrosses == C.CrossesValues.Maximum)) { SecondaryValueAxis.OtherAxisCrossedAtMaximum = true; } else { SecondaryValueAxis.OtherAxisCrossedAtMaximum = false; } // the order of axes is: // 1) primary category/date/value axis // 2) primary value axis // 3) secondary value axis // 4) secondary category/date/value axis pa.Append(SecondaryValueAxis.ToValueAxis(IsStylish)); switch (SecondaryTextAxis.AxisType) { case SLAxisType.Category: pa.Append(SecondaryTextAxis.ToCategoryAxis(IsStylish)); break; case SLAxisType.Date: pa.Append(SecondaryTextAxis.ToDateAxis(IsStylish)); break; case SLAxisType.Value: pa.Append(SecondaryTextAxis.ToValueAxis(IsStylish)); break; } } if (ShowDataTable) { pa.Append(DataTable.ToDataTable(IsStylish)); } if (ShapeProperties.HasShapeProperties) { pa.Append(ShapeProperties.ToChartShapeProperties(IsStylish)); } return(pa); }