protected DateAxis GenerateDateAxis(AxisId axisId, AxisPositionValues axisPosition, AxisId crossingAxisId, TickLabelPositionValues tickLabelPosition)
{
DateAxis dateAxis1 = new DateAxis();
AxisId axisId3 = new AxisId() { Val = axisId.Val };
Scaling scaling1 = new Scaling();
Orientation orientation1 = new Orientation() { Val = OrientationValues.MinMax };
scaling1.Append(orientation1);
AxisPosition axisPosition1 = new AxisPosition() { Val = AxisPositionValues.Bottom };
NumberingFormat numberingFormat1 = new NumberingFormat() { FormatCode = dateAxisFormat, SourceLinked = true };
MajorTickMark majorTickMark1 = new MajorTickMark() { Val = TickMarkValues.None };
TickLabelPosition tickLabelPosition1 = new TickLabelPosition() { Val = tickLabelPosition };
TextProperties textProperties1 = new TextProperties();
A::BodyProperties bodyProperties2 = new A::BodyProperties() { Rotation = -5400000, Vertical = A::TextVerticalValues.Horizontal };
A::ListStyle listStyle2 = new A::ListStyle();
A::Paragraph paragraph2 = new A::Paragraph();
A::ParagraphProperties paragraphProperties2 = new A::ParagraphProperties();
A::DefaultRunProperties defaultRunProperties2 = new A::DefaultRunProperties() { Language = DEFAULT_LANG };
paragraphProperties2.Append(defaultRunProperties2);
A::EndParagraphRunProperties endParagraphRunProperties1 = new A::EndParagraphRunProperties() { Language = DEFAULT_LANG };
paragraph2.Append(paragraphProperties2);
paragraph2.Append(endParagraphRunProperties1);
textProperties1.Append(bodyProperties2);
textProperties1.Append(listStyle2);
textProperties1.Append(paragraph2);
CrossingAxis crossingAxis1 = new CrossingAxis() { Val = crossingAxisId.Val };
Crosses crosses1 = new Crosses() { Val = CrossesValues.AutoZero };
AutoLabeled autoLabeled1 = new AutoLabeled() { Val = true };
LabelOffset labelOffset1 = new LabelOffset() { Val = (UInt16Value)100U };
dateAxis1.Append(axisId3);
dateAxis1.Append(scaling1);
dateAxis1.Append(axisPosition1);
dateAxis1.Append(numberingFormat1);
dateAxis1.Append(majorTickMark1);
dateAxis1.Append(tickLabelPosition1);
dateAxis1.Append(textProperties1);
dateAxis1.Append(crossingAxis1);
dateAxis1.Append(crosses1);
dateAxis1.Append(autoLabeled1);
dateAxis1.Append(labelOffset1);
return dateAxis1;
}
protected CategoryAxis GenerateCategoryAxis(AxisId axisId, AxisPositionValues axisPosition, string formatCode, AxisId crossingAxisId)
{
CategoryAxis categoryAxis1 = new CategoryAxis();
AxisId axisId3 = new AxisId() { Val = axisId.Val };
Scaling scaling1 = new Scaling();
Orientation orientation1 = new Orientation() { Val = OrientationValues.MinMax };
scaling1.Append(orientation1);
AxisPosition axisPosition1 = new AxisPosition() { Val = axisPosition };
NumberingFormat numberingFormat1 = new NumberingFormat() { FormatCode = formatCode, SourceLinked = true };
TickLabelPosition tickLabelPosition1 = new TickLabelPosition() { Val = TickLabelPositionValues.Low };
ChartShapeProperties chartShapeProperties5 = GenerateChartShapeProperties(3175);
TextProperties textProperties1 = new TextProperties();
A::BodyProperties bodyProperties2 = new A::BodyProperties() { Rotation = 0, Vertical = A::TextVerticalValues.Horizontal };
A::ListStyle listStyle2 = new A::ListStyle();
A::Paragraph paragraph2 = new A::Paragraph();
A::ParagraphProperties paragraphProperties2 = new A::ParagraphProperties();
A::DefaultRunProperties defaultRunProperties2 = new A::DefaultRunProperties();
paragraphProperties2.Append(defaultRunProperties2);
A::EndParagraphRunProperties endParagraphRunProperties1 = new A::EndParagraphRunProperties() { Language = DEFAULT_LANG };
paragraph2.Append(paragraphProperties2);
paragraph2.Append(endParagraphRunProperties1);
textProperties1.Append(bodyProperties2);
textProperties1.Append(listStyle2);
textProperties1.Append(paragraph2);
CrossingAxis crossingAxis1 = new CrossingAxis() { Val = crossingAxisId.Val };
Crosses crosses1 = new Crosses() { Val = CrossesValues.AutoZero };
AutoLabeled autoLabeled1 = new AutoLabeled() { Val = true };
LabelAlignment labelAlignment1 = new LabelAlignment() { Val = LabelAlignmentValues.Center };
LabelOffset labelOffset1 = new LabelOffset() { Val = (UInt16Value)100U };
TickLabelSkip tickLabelSkip1 = new TickLabelSkip() { Val = 1 };
TickMarkSkip tickMarkSkip1 = new TickMarkSkip() { Val = 1 };
categoryAxis1.Append(axisId3);
categoryAxis1.Append(scaling1);
categoryAxis1.Append(axisPosition1);
categoryAxis1.Append(numberingFormat1);
categoryAxis1.Append(tickLabelPosition1);
categoryAxis1.Append(chartShapeProperties5);
categoryAxis1.Append(textProperties1);
categoryAxis1.Append(crossingAxis1);
categoryAxis1.Append(crosses1);
categoryAxis1.Append(autoLabeled1);
categoryAxis1.Append(labelAlignment1);
categoryAxis1.Append(labelOffset1);
categoryAxis1.Append(tickLabelSkip1);
categoryAxis1.Append(tickMarkSkip1);
return categoryAxis1;
}
protected void AppendValueAxis(PlotArea plotArea, uint id, string name, uint crossingAxisId, AxisPositionValues axisPos = AxisPositionValues.Left, TickLabelPositionValues tickPos = TickLabelPositionValues.NextTo, bool showMajorGridlines = true)
{
List <OpenXmlElement> elements = GetAxisElements(id, name, crossingAxisId, tickPosition: tickPos);
elements.Add(new AxisPosition {
Val = new EnumValue <AxisPositionValues>(axisPos)
});
if (showMajorGridlines)
{
elements.Add(new MajorGridlines());
}
elements.Add(new DocumentFormat.OpenXml.Drawing.Charts.NumberingFormat()
{
FormatCode = new StringValue("General"),
SourceLinked = new BooleanValue(true)
});
elements.Add(new CrossBetween {
Val = new EnumValue <CrossBetweenValues>(CrossBetweenValues.Between)
});
plotArea.AppendChild(new ValueAxis(elements));
}
protected ValueAxis GenerateValueAxis(AxisId axisId, AxisPositionValues position, string formatCode, AxisId crossingAxisId)
{
ValueAxis valueAxis1 = new ValueAxis();
AxisId axisId4 = new AxisId() { Val = (UInt32Value)axisId.Val };
Scaling scaling2 = new Scaling();
Orientation orientation2 = new Orientation() { Val = OrientationValues.MinMax };
scaling2.Append(orientation2);
AxisPosition axisPosition2 = new AxisPosition() { Val = position };
MajorGridlines majorGridlines1 = new MajorGridlines();
ChartShapeProperties chartShapeProperties4 = GenerateChartShapeProperties(3175);
majorGridlines1.Append(chartShapeProperties4);
NumberingFormat numberingFormat2 = new NumberingFormat() { FormatCode = formatCode, SourceLinked = false };
TickLabelPosition tickLabelPosition2 = new TickLabelPosition() { Val = TickLabelPositionValues.NextTo };
ChartShapeProperties chartShapeProperties5 = GenerateChartShapeProperties(3175);
TextProperties textProperties2 = new TextProperties();
A::BodyProperties bodyProperties3 = new A::BodyProperties() { Rotation = 0, Vertical = A::TextVerticalValues.Horizontal };
A::ListStyle listStyle3 = new A::ListStyle();
A::Paragraph paragraph3 = new A::Paragraph();
A::ParagraphProperties paragraphProperties3 = new A::ParagraphProperties();
A::DefaultRunProperties defaultRunProperties3 = new A::DefaultRunProperties() { Language = DEFAULT_LANG };
A::SolidFill solidFill8 = new A::SolidFill();
A::RgbColorModelHex rgbColorModelHex8 = new A::RgbColorModelHex() { Val = "000000" };
solidFill8.Append(rgbColorModelHex8);
paragraphProperties3.Append(defaultRunProperties3);
A::EndParagraphRunProperties endParagraphRunProperties2 = new A::EndParagraphRunProperties() { Language = DEFAULT_LANG };
paragraph3.Append(paragraphProperties3);
paragraph3.Append(endParagraphRunProperties2);
textProperties2.Append(bodyProperties3);
textProperties2.Append(listStyle3);
textProperties2.Append(paragraph3);
CrossingAxis crossingAxis2 = new CrossingAxis() { Val = (UInt32Value)crossingAxisId.Val };
Crosses crosses2 = new Crosses() { Val = CrossesValues.AutoZero };
CrossBetween crossBetween1 = new CrossBetween() { Val = CrossBetweenValues.Between };
valueAxis1.Append(axisId4);
valueAxis1.Append(scaling2);
valueAxis1.Append(axisPosition2);
valueAxis1.Append(majorGridlines1);
valueAxis1.Append(numberingFormat2);
valueAxis1.Append(tickLabelPosition2);
valueAxis1.Append(chartShapeProperties5);
valueAxis1.Append(textProperties2);
valueAxis1.Append(crossingAxis2);
valueAxis1.Append(crosses2);
valueAxis1.Append(crossBetween1);
return valueAxis1;
}
protected ValueAxis GenerateValueAxis(AxisId axisId, AxisPositionValues position, AxisId crossingAxisId)
{
ValueAxis valueAxis1 = new ValueAxis();
AxisId axisId4 = new AxisId() { Val = axisId.Val };
Scaling scaling2 = new Scaling();
Orientation orientation2 = new Orientation() { Val = OrientationValues.MinMax };
scaling2.Append(orientation2);
AxisPosition axisPosition2 = new AxisPosition() { Val = position };
MajorGridlines majorGridlines1 = new MajorGridlines();
NumberingFormat numberingFormat2 = new NumberingFormat() { FormatCode = valueAxisFormat, SourceLinked = false };
MajorTickMark majorTickMark2 = new MajorTickMark() { Val = TickMarkValues.None };
TickLabelPosition tickLabelPosition2 = new TickLabelPosition() { Val = TickLabelPositionValues.NextTo };
ChartShapeProperties chartShapeProperties4 = GenerateChartShapeProperties(9525);
TextProperties textProperties2 = new TextProperties();
A::BodyProperties bodyProperties3 = new A::BodyProperties();
A::ListStyle listStyle3 = new A::ListStyle();
A::Paragraph paragraph3 = new A::Paragraph();
A::ParagraphProperties paragraphProperties3 = new A::ParagraphProperties();
A::DefaultRunProperties defaultRunProperties3 = new A::DefaultRunProperties() { Language = DEFAULT_LANG };
paragraphProperties3.Append(defaultRunProperties3);
A::EndParagraphRunProperties endParagraphRunProperties2 = new A::EndParagraphRunProperties() { Language = DEFAULT_LANG };
paragraph3.Append(paragraphProperties3);
paragraph3.Append(endParagraphRunProperties2);
textProperties2.Append(bodyProperties3);
textProperties2.Append(listStyle3);
textProperties2.Append(paragraph3);
CrossingAxis crossingAxis2 = new CrossingAxis() { Val = crossingAxisId.Val };
Crosses crosses2 = new Crosses() { Val = CrossesValues.AutoZero };
CrossBetween crossBetween1 = new CrossBetween() { Val = CrossBetweenValues.Between };
valueAxis1.Append(axisId4);
valueAxis1.Append(scaling2);
valueAxis1.Append(axisPosition2);
valueAxis1.Append(majorGridlines1);
valueAxis1.Append(numberingFormat2);
valueAxis1.Append(majorTickMark2);
valueAxis1.Append(tickLabelPosition2);
valueAxis1.Append(chartShapeProperties4);
valueAxis1.Append(textProperties2);
valueAxis1.Append(crossingAxis2);
valueAxis1.Append(crosses2);
valueAxis1.Append(crossBetween1);
return valueAxis1;
}
protected CategoryAxis GenerateCategoryAxis(AxisId axisId, AxisPositionValues axisPosition, string formatCode, AxisId crossingAxisId)
{
CategoryAxis categoryAxis1 = new CategoryAxis();
AxisId axisId1 = new AxisId() { Val = axisId.Val };
Scaling scaling1 = new Scaling();
Orientation orientation1 = new Orientation() { Val = OrientationValues.MinMax };
scaling1.Append(orientation1);
AxisPosition axisPosition1 = new AxisPosition() { Val = AxisPositionValues.Bottom };
NumberingFormat numberingFormat1 = new NumberingFormat() { FormatCode = formatCode, SourceLinked = true };
TickLabelPosition tickLabelPosition1 = new TickLabelPosition() { Val = TickLabelPositionValues.Low };
ChartShapeProperties chartShapeProperties1 = GenerateChartShapeProperties(3175);
TextProperties textProperties1 = new TextProperties();
A::BodyProperties bodyProperties1 = new A::BodyProperties() { Rotation = -1800000, Vertical = A::TextVerticalValues.Horizontal };
A::ListStyle listStyle1 = new A::ListStyle();
A::Paragraph paragraph1 = new A::Paragraph();
A::ParagraphProperties paragraphProperties1 = new A::ParagraphProperties();
A::DefaultRunProperties defaultRunProperties1 = new A::DefaultRunProperties() { Language = DEFAULT_LANG, FontSize = 1000, Bold = false, Italic = false, Underline = A::TextUnderlineValues.None, Strike = A::TextStrikeValues.NoStrike, Baseline = 0 };
A::SolidFill solidFill2 = new A::SolidFill();
A::RgbColorModelHex rgbColorModelHex2 = new A::RgbColorModelHex() { Val = "000000" };
solidFill2.Append(rgbColorModelHex2);
defaultRunProperties1.Append(solidFill2);
paragraphProperties1.Append(defaultRunProperties1);
A::EndParagraphRunProperties endParagraphRunProperties1 = new A::EndParagraphRunProperties() { Language = DEFAULT_LANG };
paragraph1.Append(paragraphProperties1);
paragraph1.Append(endParagraphRunProperties1);
textProperties1.Append(bodyProperties1);
textProperties1.Append(listStyle1);
textProperties1.Append(paragraph1);
CrossingAxis crossingAxis1 = new CrossingAxis() { Val = (UInt32Value)crossingAxisId.Val };
Crosses crosses1 = new Crosses() { Val = CrossesValues.AutoZero };
AutoLabeled autoLabeled1 = new AutoLabeled() { Val = true };
LabelAlignment labelAlignment1 = new LabelAlignment() { Val = LabelAlignmentValues.Center };
LabelOffset labelOffset1 = new LabelOffset() { Val = (UInt16Value)100U };
TickLabelSkip tickLabelSkip1 = new TickLabelSkip() { Val = 1 };
TickMarkSkip tickMarkSkip1 = new TickMarkSkip() { Val = 1 };
categoryAxis1.Append(axisId1);
categoryAxis1.Append(scaling1);
categoryAxis1.Append(axisPosition1);
categoryAxis1.Append(numberingFormat1);
categoryAxis1.Append(tickLabelPosition1);
categoryAxis1.Append(chartShapeProperties1);
categoryAxis1.Append(textProperties1);
categoryAxis1.Append(crossingAxis1);
categoryAxis1.Append(crosses1);
categoryAxis1.Append(autoLabeled1);
categoryAxis1.Append(labelAlignment1);
categoryAxis1.Append(labelOffset1);
categoryAxis1.Append(tickLabelSkip1);
categoryAxis1.Append(tickMarkSkip1);
return categoryAxis1;
}
