public Chart GenerateChart(string title) { // c:chart (Chart) Chart chart1 = new Chart(); // c:title (Title) Title title1 = GenerateTitle(title, TITLE_FONT_SIZE); // c:plotArea (PlotArea) PlotArea plotArea1 = new PlotArea(); // c:layout (Layout) Layout layout2 = new Layout(); // c:lineChart (LineChart) LineChart lineChart1 = new LineChart(); // c:grouping (Grouping) Grouping grouping1 = new Grouping() { Val = GroupingValues.Standard }; // c:marker (Marker) ShowMarker showMarker1 = new ShowMarker() { Val = true }; // c:axId (AxisId) AxisId axisId1 = new AxisId() { Val = (UInt32Value)54573696U }; AxisId axisId2 = new AxisId() { Val = (UInt32Value)54657408U }; lineChart1.Append(grouping1); lineChart1.Append(showMarker1); lineChart1.Append(axisId1); lineChart1.Append(axisId2); // c:dateAx (DateAxis) DateAxis dateAxis1 = GenerateDateAxis(axisId1, AxisPositionValues.Bottom, axisId2, TickLabelPositionValues.Low); // c:valAx (ValueAxis) ValueAxis valueAxis1 = GenerateValueAxis(axisId2, AxisPositionValues.Left, axisId1); // c:plotArea (PlotArea) plotArea1.Append(layout2); plotArea1.Append(lineChart1); plotArea1.Append(dateAxis1); plotArea1.Append(valueAxis1); // c:legend (Legend) Legend legend1 = GenerateLegend(LegendPositionValues.Bottom); // c:plotVisOnly (PlotVisibleOnly) PlotVisibleOnly plotVisibleOnly1 = new PlotVisibleOnly() { Val = true }; chart1.Append(title1); chart1.Append(plotArea1); chart1.Append(legend1); chart1.Append(plotVisibleOnly1); return chart1; }
public Chart GenerateChart(string title) { // c:chart (Chart) Chart chart1 = new Chart(); // c:title (Title) Title title1 = GenerateTitle(title, TITLE_FONT_SIZE); // c:plotArea (PlotArea) PlotArea plotArea1 = new PlotArea(); // c:layout (Layout) Layout layout2 = new Layout(); LineChart lineChart1 = new LineChart(); Grouping grouping1 = new Grouping() { Val = GroupingValues.Standard }; ShowMarker showMarker1 = new ShowMarker() { Val = true }; AxisId axisId1 = new AxisId() { Val = (UInt32Value)102222464U }; AxisId axisId2 = new AxisId() { Val = (UInt32Value)92672384U }; lineChart1.Append(grouping1); lineChart1.Append(showMarker1); lineChart1.Append(axisId1); lineChart1.Append(axisId2); DateAxis dateAxis1 = GenerateDateAxis(axisId1, AxisPositionValues.Bottom, axisId2, TickLabelPositionValues.High); ValueAxis valueAxis1 = GenerateValueAxis(axisId2, AxisPositionValues.Left, axisId1); plotArea1.Append(layout2); plotArea1.Append(lineChart1); plotArea1.Append(dateAxis1); plotArea1.Append(valueAxis1); Legend legend1 = GenerateLegend(LegendPositionValues.Bottom); PlotVisibleOnly plotVisibleOnly1 = new PlotVisibleOnly() { Val = true }; chart1.Append(title1); chart1.Append(plotArea1); chart1.Append(legend1); chart1.Append(plotVisibleOnly1); return chart1; }
// 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; }
// Generates content of chartPart1. private void GenerateChartPart1Content(ChartPart chartPart1) { 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"); C.Date1904 date19041 = new C.Date1904() { Val = false }; C.EditingLanguage editingLanguage1 = new C.EditingLanguage() { Val = "en-US" }; C.RoundedCorners roundedCorners1 = new C.RoundedCorners() { Val = false }; 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 = 102 }; alternateContentChoice1.Append(style1); AlternateContentFallback alternateContentFallback1 = new AlternateContentFallback(); C.Style style2 = new C.Style() { Val = 2 }; alternateContentFallback1.Append(style2); alternateContent1.Append(alternateContentChoice1); alternateContent1.Append(alternateContentFallback1); C.Chart chart1 = new C.Chart(); C.AutoTitleDeleted autoTitleDeleted1 = new C.AutoTitleDeleted() { Val = true }; C.PlotArea plotArea1 = new C.PlotArea(); C.Layout layout1 = new C.Layout(); C.LineChart lineChart1 = new C.LineChart(); C.Grouping grouping1 = new C.Grouping() { Val = C.GroupingValues.Standard }; C.VaryColors varyColors1 = new C.VaryColors() { Val = false }; C.LineChartSeries lineChartSeries1 = new C.LineChartSeries(); 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.StringReference stringReference1 = new C.StringReference(); C.Formula formula1 = new C.Formula(); formula1.Text = "Sheet1!$B$1"; C.StringCache stringCache1 = new C.StringCache(); C.PointCount pointCount1 = new C.PointCount() { Val = (UInt32Value)1U }; C.StringPoint stringPoint1 = new C.StringPoint() { Index = (UInt32Value)0U }; C.NumericValue numericValue1 = new C.NumericValue(); numericValue1.Text = "Series 1"; stringPoint1.Append(numericValue1); stringCache1.Append(pointCount1); stringCache1.Append(stringPoint1); stringReference1.Append(formula1); stringReference1.Append(stringCache1); seriesText1.Append(stringReference1); C.Marker marker1 = new C.Marker(); C.Symbol symbol1 = new C.Symbol() { Val = C.MarkerStyleValues.None }; marker1.Append(symbol1); C.CategoryAxisData categoryAxisData1 = new C.CategoryAxisData(); C.StringReference stringReference2 = new C.StringReference(); C.Formula formula2 = new C.Formula(); formula2.Text = "Sheet1!$A$2:$A$5"; C.StringCache stringCache2 = new C.StringCache(); C.PointCount pointCount2 = new C.PointCount() { Val = (UInt32Value)4U }; C.StringPoint stringPoint2 = new C.StringPoint() { Index = (UInt32Value)0U }; C.NumericValue numericValue2 = new C.NumericValue(); numericValue2.Text = "Category 1"; stringPoint2.Append(numericValue2); C.StringPoint stringPoint3 = new C.StringPoint() { Index = (UInt32Value)1U }; C.NumericValue numericValue3 = new C.NumericValue(); numericValue3.Text = "Category 2"; stringPoint3.Append(numericValue3); C.StringPoint stringPoint4 = new C.StringPoint() { Index = (UInt32Value)2U }; C.NumericValue numericValue4 = new C.NumericValue(); numericValue4.Text = "Category 3"; stringPoint4.Append(numericValue4); C.StringPoint stringPoint5 = new C.StringPoint() { Index = (UInt32Value)3U }; C.NumericValue numericValue5 = new C.NumericValue(); numericValue5.Text = "Category 4"; stringPoint5.Append(numericValue5); stringCache2.Append(pointCount2); stringCache2.Append(stringPoint2); stringCache2.Append(stringPoint3); stringCache2.Append(stringPoint4); stringCache2.Append(stringPoint5); stringReference2.Append(formula2); stringReference2.Append(stringCache2); categoryAxisData1.Append(stringReference2); C.Values values1 = new C.Values(); C.NumberReference numberReference1 = new C.NumberReference(); C.Formula formula3 = new C.Formula(); formula3.Text = "Sheet1!$B$2:$B$5"; C.NumberingCache numberingCache1 = new C.NumberingCache(); C.FormatCode formatCode1 = new C.FormatCode(); formatCode1.Text = "General"; C.PointCount pointCount3 = new C.PointCount() { Val = (UInt32Value)4U }; C.NumericPoint numericPoint1 = new C.NumericPoint() { Index = (UInt32Value)0U }; C.NumericValue numericValue6 = new C.NumericValue(); numericValue6.Text = "4.3"; numericPoint1.Append(numericValue6); C.NumericPoint numericPoint2 = new C.NumericPoint() { Index = (UInt32Value)1U }; C.NumericValue numericValue7 = new C.NumericValue(); numericValue7.Text = "2.5"; numericPoint2.Append(numericValue7); C.NumericPoint numericPoint3 = new C.NumericPoint() { Index = (UInt32Value)2U }; C.NumericValue numericValue8 = new C.NumericValue(); numericValue8.Text = "3.5"; numericPoint3.Append(numericValue8); C.NumericPoint numericPoint4 = new C.NumericPoint() { Index = (UInt32Value)3U }; C.NumericValue numericValue9 = new C.NumericValue(); numericValue9.Text = "4.5"; numericPoint4.Append(numericValue9); numberingCache1.Append(formatCode1); numberingCache1.Append(pointCount3); numberingCache1.Append(numericPoint1); numberingCache1.Append(numericPoint2); numberingCache1.Append(numericPoint3); numberingCache1.Append(numericPoint4); numberReference1.Append(formula3); numberReference1.Append(numberingCache1); values1.Append(numberReference1); C.Smooth smooth1 = new C.Smooth() { Val = false }; lineChartSeries1.Append(index1); lineChartSeries1.Append(order1); lineChartSeries1.Append(seriesText1); lineChartSeries1.Append(marker1); lineChartSeries1.Append(categoryAxisData1); lineChartSeries1.Append(values1); lineChartSeries1.Append(smooth1); C.LineChartSeries lineChartSeries2 = new C.LineChartSeries(); C.Index index2 = new C.Index() { Val = (UInt32Value)1U }; C.Order order2 = new C.Order() { Val = (UInt32Value)1U }; C.SeriesText seriesText2 = new C.SeriesText(); C.StringReference stringReference3 = new C.StringReference(); C.Formula formula4 = new C.Formula(); formula4.Text = "Sheet1!$C$1"; C.StringCache stringCache3 = new C.StringCache(); C.PointCount pointCount4 = new C.PointCount() { Val = (UInt32Value)1U }; C.StringPoint stringPoint6 = new C.StringPoint() { Index = (UInt32Value)0U }; C.NumericValue numericValue10 = new C.NumericValue(); numericValue10.Text = "Series 2"; stringPoint6.Append(numericValue10); stringCache3.Append(pointCount4); stringCache3.Append(stringPoint6); stringReference3.Append(formula4); stringReference3.Append(stringCache3); seriesText2.Append(stringReference3); C.Marker marker2 = new C.Marker(); C.Symbol symbol2 = new C.Symbol() { Val = C.MarkerStyleValues.None }; marker2.Append(symbol2); C.CategoryAxisData categoryAxisData2 = new C.CategoryAxisData(); C.StringReference stringReference4 = new C.StringReference(); C.Formula formula5 = new C.Formula(); formula5.Text = "Sheet1!$A$2:$A$5"; C.StringCache stringCache4 = new C.StringCache(); C.PointCount pointCount5 = new C.PointCount() { Val = (UInt32Value)4U }; C.StringPoint stringPoint7 = new C.StringPoint() { Index = (UInt32Value)0U }; C.NumericValue numericValue11 = new C.NumericValue(); numericValue11.Text = "Category 1"; stringPoint7.Append(numericValue11); C.StringPoint stringPoint8 = new C.StringPoint() { Index = (UInt32Value)1U }; C.NumericValue numericValue12 = new C.NumericValue(); numericValue12.Text = "Category 2"; stringPoint8.Append(numericValue12); C.StringPoint stringPoint9 = new C.StringPoint() { Index = (UInt32Value)2U }; C.NumericValue numericValue13 = new C.NumericValue(); numericValue13.Text = "Category 3"; stringPoint9.Append(numericValue13); C.StringPoint stringPoint10 = new C.StringPoint() { Index = (UInt32Value)3U }; C.NumericValue numericValue14 = new C.NumericValue(); numericValue14.Text = "Category 4"; stringPoint10.Append(numericValue14); stringCache4.Append(pointCount5); stringCache4.Append(stringPoint7); stringCache4.Append(stringPoint8); stringCache4.Append(stringPoint9); stringCache4.Append(stringPoint10); stringReference4.Append(formula5); stringReference4.Append(stringCache4); categoryAxisData2.Append(stringReference4); C.Values values2 = new C.Values(); C.NumberReference numberReference2 = new C.NumberReference(); C.Formula formula6 = new C.Formula(); formula6.Text = "Sheet1!$C$2:$C$5"; C.NumberingCache numberingCache2 = new C.NumberingCache(); C.FormatCode formatCode2 = new C.FormatCode(); formatCode2.Text = "General"; C.PointCount pointCount6 = new C.PointCount() { Val = (UInt32Value)4U }; C.NumericPoint numericPoint5 = new C.NumericPoint() { Index = (UInt32Value)0U }; C.NumericValue numericValue15 = new C.NumericValue(); numericValue15.Text = "2.4"; numericPoint5.Append(numericValue15); C.NumericPoint numericPoint6 = new C.NumericPoint() { Index = (UInt32Value)1U }; C.NumericValue numericValue16 = new C.NumericValue(); numericValue16.Text = "4.4000000000000004"; numericPoint6.Append(numericValue16); C.NumericPoint numericPoint7 = new C.NumericPoint() { Index = (UInt32Value)2U }; C.NumericValue numericValue17 = new C.NumericValue(); numericValue17.Text = "1.8"; numericPoint7.Append(numericValue17); C.NumericPoint numericPoint8 = new C.NumericPoint() { Index = (UInt32Value)3U }; C.NumericValue numericValue18 = new C.NumericValue(); numericValue18.Text = "2.8"; numericPoint8.Append(numericValue18); numberingCache2.Append(formatCode2); numberingCache2.Append(pointCount6); numberingCache2.Append(numericPoint5); numberingCache2.Append(numericPoint6); numberingCache2.Append(numericPoint7); numberingCache2.Append(numericPoint8); numberReference2.Append(formula6); numberReference2.Append(numberingCache2); values2.Append(numberReference2); C.Smooth smooth2 = new C.Smooth() { Val = false }; lineChartSeries2.Append(index2); lineChartSeries2.Append(order2); lineChartSeries2.Append(seriesText2); lineChartSeries2.Append(marker2); lineChartSeries2.Append(categoryAxisData2); lineChartSeries2.Append(values2); lineChartSeries2.Append(smooth2); C.LineChartSeries lineChartSeries3 = new C.LineChartSeries(); C.Index index3 = new C.Index() { Val = (UInt32Value)2U }; C.Order order3 = new C.Order() { Val = (UInt32Value)2U }; C.SeriesText seriesText3 = new C.SeriesText(); C.StringReference stringReference5 = new C.StringReference(); C.Formula formula7 = new C.Formula(); formula7.Text = "Sheet1!$D$1"; C.StringCache stringCache5 = new C.StringCache(); C.PointCount pointCount7 = new C.PointCount() { Val = (UInt32Value)1U }; C.StringPoint stringPoint11 = new C.StringPoint() { Index = (UInt32Value)0U }; C.NumericValue numericValue19 = new C.NumericValue(); numericValue19.Text = "Series 3"; stringPoint11.Append(numericValue19); stringCache5.Append(pointCount7); stringCache5.Append(stringPoint11); stringReference5.Append(formula7); stringReference5.Append(stringCache5); seriesText3.Append(stringReference5); C.Marker marker3 = new C.Marker(); C.Symbol symbol3 = new C.Symbol() { Val = C.MarkerStyleValues.None }; marker3.Append(symbol3); C.CategoryAxisData categoryAxisData3 = new C.CategoryAxisData(); C.StringReference stringReference6 = new C.StringReference(); C.Formula formula8 = new C.Formula(); formula8.Text = "Sheet1!$A$2:$A$5"; C.StringCache stringCache6 = new C.StringCache(); C.PointCount pointCount8 = new C.PointCount() { Val = (UInt32Value)4U }; C.StringPoint stringPoint12 = new C.StringPoint() { Index = (UInt32Value)0U }; C.NumericValue numericValue20 = new C.NumericValue(); numericValue20.Text = "Category 1"; stringPoint12.Append(numericValue20); C.StringPoint stringPoint13 = new C.StringPoint() { Index = (UInt32Value)1U }; C.NumericValue numericValue21 = new C.NumericValue(); numericValue21.Text = "Category 2"; stringPoint13.Append(numericValue21); C.StringPoint stringPoint14 = new C.StringPoint() { Index = (UInt32Value)2U }; C.NumericValue numericValue22 = new C.NumericValue(); numericValue22.Text = "Category 3"; stringPoint14.Append(numericValue22); C.StringPoint stringPoint15 = new C.StringPoint() { Index = (UInt32Value)3U }; C.NumericValue numericValue23 = new C.NumericValue(); numericValue23.Text = "Category 4"; stringPoint15.Append(numericValue23); stringCache6.Append(pointCount8); stringCache6.Append(stringPoint12); stringCache6.Append(stringPoint13); stringCache6.Append(stringPoint14); stringCache6.Append(stringPoint15); stringReference6.Append(formula8); stringReference6.Append(stringCache6); categoryAxisData3.Append(stringReference6); C.Values values3 = new C.Values(); C.NumberReference numberReference3 = new C.NumberReference(); C.Formula formula9 = new C.Formula(); formula9.Text = "Sheet1!$D$2:$D$5"; C.NumberingCache numberingCache3 = new C.NumberingCache(); C.FormatCode formatCode3 = new C.FormatCode(); formatCode3.Text = "General"; C.PointCount pointCount9 = new C.PointCount() { Val = (UInt32Value)4U }; C.NumericPoint numericPoint9 = new C.NumericPoint() { Index = (UInt32Value)0U }; C.NumericValue numericValue24 = new C.NumericValue(); numericValue24.Text = "2"; numericPoint9.Append(numericValue24); C.NumericPoint numericPoint10 = new C.NumericPoint() { Index = (UInt32Value)1U }; C.NumericValue numericValue25 = new C.NumericValue(); numericValue25.Text = "2"; numericPoint10.Append(numericValue25); C.NumericPoint numericPoint11 = new C.NumericPoint() { Index = (UInt32Value)2U }; C.NumericValue numericValue26 = new C.NumericValue(); numericValue26.Text = "3"; numericPoint11.Append(numericValue26); C.NumericPoint numericPoint12 = new C.NumericPoint() { Index = (UInt32Value)3U }; C.NumericValue numericValue27 = new C.NumericValue(); numericValue27.Text = "5"; numericPoint12.Append(numericValue27); numberingCache3.Append(formatCode3); numberingCache3.Append(pointCount9); numberingCache3.Append(numericPoint9); numberingCache3.Append(numericPoint10); numberingCache3.Append(numericPoint11); numberingCache3.Append(numericPoint12); numberReference3.Append(formula9); numberReference3.Append(numberingCache3); values3.Append(numberReference3); C.Smooth smooth3 = new C.Smooth() { Val = false }; lineChartSeries3.Append(index3); lineChartSeries3.Append(order3); lineChartSeries3.Append(seriesText3); lineChartSeries3.Append(marker3); lineChartSeries3.Append(categoryAxisData3); lineChartSeries3.Append(values3); lineChartSeries3.Append(smooth3); 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.ShowMarker showMarker1 = new C.ShowMarker() { Val = true }; C.Smooth smooth4 = new C.Smooth() { Val = false }; C.AxisId axisId1 = new C.AxisId() { Val = (UInt32Value)231952384U }; C.AxisId axisId2 = new C.AxisId() { Val = (UInt32Value)231953920U }; lineChart1.Append(grouping1); lineChart1.Append(varyColors1); lineChart1.Append(lineChartSeries1); lineChart1.Append(lineChartSeries2); lineChart1.Append(lineChartSeries3); lineChart1.Append(dataLabels1); lineChart1.Append(showMarker1); lineChart1.Append(smooth4); lineChart1.Append(axisId1); lineChart1.Append(axisId2); C.CategoryAxis categoryAxis1 = new C.CategoryAxis(); C.AxisId axisId3 = new C.AxisId() { Val = (UInt32Value)231952384U }; 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 = false }; C.AxisPosition axisPosition1 = new C.AxisPosition() { Val = C.AxisPositionValues.Bottom }; C.MajorTickMark majorTickMark1 = new C.MajorTickMark() { Val = C.TickMarkValues.Outside }; C.MinorTickMark minorTickMark1 = new C.MinorTickMark() { Val = C.TickMarkValues.None }; C.TickLabelPosition tickLabelPosition1 = new C.TickLabelPosition() { Val = C.TickLabelPositionValues.NextTo }; C.CrossingAxis crossingAxis1 = new C.CrossingAxis() { Val = (UInt32Value)231953920U }; 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 = false }; categoryAxis1.Append(axisId3); categoryAxis1.Append(scaling1); categoryAxis1.Append(delete1); categoryAxis1.Append(axisPosition1); 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)231953920U }; 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 = false }; C.AxisPosition axisPosition2 = new C.AxisPosition() { Val = C.AxisPositionValues.Left }; C.MajorGridlines majorGridlines1 = new C.MajorGridlines(); C.NumberingFormat numberingFormat1 = new C.NumberingFormat() { FormatCode = "General", SourceLinked = true }; C.MajorTickMark majorTickMark2 = new C.MajorTickMark() { Val = C.TickMarkValues.Outside }; C.MinorTickMark minorTickMark2 = new C.MinorTickMark() { Val = C.TickMarkValues.None }; C.TickLabelPosition tickLabelPosition2 = new C.TickLabelPosition() { Val = C.TickLabelPositionValues.NextTo }; C.CrossingAxis crossingAxis2 = new C.CrossingAxis() { Val = (UInt32Value)231952384U }; C.Crosses crosses2 = new C.Crosses() { Val = C.CrossesValues.AutoZero }; C.CrossBetween crossBetween1 = new C.CrossBetween() { Val = C.CrossBetweenValues.Between }; valueAxis1.Append(axisId4); valueAxis1.Append(scaling2); valueAxis1.Append(delete2); valueAxis1.Append(axisPosition2); valueAxis1.Append(majorGridlines1); valueAxis1.Append(numberingFormat1); valueAxis1.Append(majorTickMark2); valueAxis1.Append(minorTickMark2); valueAxis1.Append(tickLabelPosition2); valueAxis1.Append(crossingAxis2); valueAxis1.Append(crosses2); valueAxis1.Append(crossBetween1); plotArea1.Append(layout1); plotArea1.Append(lineChart1); plotArea1.Append(categoryAxis1); plotArea1.Append(valueAxis1); C.Legend legend1 = new C.Legend(); C.LegendPosition legendPosition1 = new C.LegendPosition() { Val = C.LegendPositionValues.Right }; C.Overlay overlay1 = new C.Overlay() { Val = false }; legend1.Append(legendPosition1); legend1.Append(overlay1); C.PlotVisibleOnly plotVisibleOnly1 = new C.PlotVisibleOnly() { Val = true }; C.DisplayBlanksAs displayBlanksAs1 = new C.DisplayBlanksAs() { Val = C.DisplayBlanksAsValues.Gap }; C.ShowDataLabelsOverMaximum showDataLabelsOverMaximum1 = new C.ShowDataLabelsOverMaximum() { Val = false }; chart1.Append(autoTitleDeleted1); chart1.Append(plotArea1); chart1.Append(legend1); chart1.Append(plotVisibleOnly1); chart1.Append(displayBlanksAs1); chart1.Append(showDataLabelsOverMaximum1); C.ExternalData externalData1 = new C.ExternalData() { Id = "rId1" }; C.AutoUpdate autoUpdate1 = new C.AutoUpdate() { Val = false }; externalData1.Append(autoUpdate1); chartSpace1.Append(date19041); chartSpace1.Append(editingLanguage1); chartSpace1.Append(roundedCorners1); chartSpace1.Append(alternateContent1); chartSpace1.Append(chart1); chartSpace1.Append(externalData1); chartPart1.ChartSpace = chartSpace1; }