Class ChartConstants

This class contains constants required for charts parsing and serialization in Excel 2007 format.

Inheritance
System.Object
ChartConstants
Namespace: Syncfusion.XlsIO.Implementation.XmlSerialization.Constants
Assembly: Syncfusion.XlsIO.UWP.dll
Syntax
public sealed class ChartConstants : Object

Fields

AlternateContentTag

Alternate content tag

Declaration
public const string AlternateContentTag = "AlternateContent"
Field Value
Type
System.String

Anglevalue

Angle value

Declaration
public const int Anglevalue = 60000
Field Value
Type
System.Int32

Area3DChartTag

This element specifies the 3-D area series on this chart.

Declaration
public const string Area3DChartTag = "area3DChart"
Field Value
Type
System.String

AreaChartTag

This element specifies the 2-D area series on this chart.

Declaration
public const string AreaChartTag = "areaChart"
Field Value
Type
System.String

AutoCategoryAxis

This element specifies that this axis is a date or text axis based on the data that is used for the axis labels, not a specific choice.

Declaration
public const string AutoCategoryAxis = "auto"
Field Value
Type
System.String

AutoTitleDeletedTag

Auto title deleted tag

Declaration
public const string AutoTitleDeletedTag = "autoTitleDeleted"
Field Value
Type
System.String

AxisIdTag

When specified as a child element of valAx, dateAx, catAx, or serAx, this element specifies the identifier for the axis. When specified as a child element of a chart, this element specifies the identifier of an axis that defines the coordinate space of the chart.

Declaration
public const string AxisIdTag = "axId"
Field Value
Type
System.String

AxisOrientationTag

This element specifies the stretching and stacking of the picture on the data point, series, wall, or floor.

Declaration
public const string AxisOrientationTag = "orientation"
Field Value
Type
System.String

AxisPosBottom

Specifies that the axis shall be displayed at the bottom of the plot area.

Declaration
public const string AxisPosBottom = "b"
Field Value
Type
System.String

AxisPositionTag

This element specifies the position of the axis on the chart.

Declaration
public const string AxisPositionTag = "axPos"
Field Value
Type
System.String

AxisPosLeft

Specifies that the axis shall be displayed at the left of the plot area.

Declaration
public const string AxisPosLeft = "l"
Field Value
Type
System.String

AxisPosRight

Specifies that the axis shall be displayed at the right of the plot area.

Declaration
public const string AxisPosRight = "r"
Field Value
Type
System.String

AxisPosTop

Specifies that the axis shall be displayed at the top of the plot area.

Declaration
public const string AxisPosTop = "t"
Field Value
Type
System.String

BackWallTag

This element specifies the back wall of the chart.

Declaration
public const string BackWallTag = "backWall"
Field Value
Type
System.String

BandFormats

This element specifes the band formats

Declaration
public const string BandFormats = "bandFmts"
Field Value
Type
System.String

Bar3DChartTag

This element contains the 3-D bar or column series on this chart.

Declaration
public const string Bar3DChartTag = "bar3DChart"
Field Value
Type
System.String

BarChartTag

This element contains the 2-D bar or column series on this chart.

Declaration
public const string BarChartTag = "barChart"
Field Value
Type
System.String

BarDirectionBar

Specifies that the chart is a bar chart - the data markers are horizontal rectangles.

Declaration
public const string BarDirectionBar = "bar"
Field Value
Type
System.String

BarDirectionColumn

Specifies that the chart is a column chart - the data markers are vertical rectangles.

Declaration
public const string BarDirectionColumn = "col"
Field Value
Type
System.String

BarDirectionTag

This element specifies whether the series form a bar (horizontal) chart or a column (vertical) chart.

Declaration
public const string BarDirectionTag = "barDir"
Field Value
Type
System.String

BarGroupingTag

This element specifies the type of grouping for a bar chart.

Declaration
public const string BarGroupingTag = "grouping"
Field Value
Type
System.String

BarShapeBox

Specifies the chart shall be drawn with a box shape.

Declaration
public const string BarShapeBox = "box"
Field Value
Type
System.String

BarShapeCone

Specifies the chart shall be drawn as a cone, with the base of the cone on the floor and the point of the cone at the top of the data marker.

Declaration
public const string BarShapeCone = "cone"
Field Value
Type
System.String

BarShapeConeToMax

Specifies the chart shall be drawn with truncated cones such that the point of the cone would be the maximum data value.

Declaration
public const string BarShapeConeToMax = "coneToMax"
Field Value
Type
System.String

BarShapeCylinder

Specifies the chart shall be drawn as a cylinder.

Declaration
public const string BarShapeCylinder = "cylinder"
Field Value
Type
System.String

BarShapePyramid

Specifies the chart shall be drawn as a rectangular pyramid, with the base of the pyramid on the floor and the point of the pyramid at the top of the data marker.

Declaration
public const string BarShapePyramid = "pyramid"
Field Value
Type
System.String

BarShapePyramidToMax

Specifies the chart shall be drawn with truncated cones such that the point of the cone would be the maximum data value.

Declaration
public const string BarShapePyramidToMax = "pyramidToMax"
Field Value
Type
System.String

BarShapeTag

This element specifies the shape of a series or a 3-D bar chart.

Declaration
public const string BarShapeTag = "shape"
Field Value
Type
System.String

BaseTimeUnitTag

This element specifies the smallest time unit that is represented on the date axis.

Declaration
public const string BaseTimeUnitTag = "baseTimeUnit"
Field Value
Type
System.String

BetweenValue

Specifies the value axis shall cross the category axis between data markers.

Declaration
public const string BetweenValue = "between"
Field Value
Type
System.String

BevelValue

Bevel value

Declaration
public const int BevelValue = 12700
Field Value
Type
System.Int32

BlurValue

Blur value

Declaration
public const int BlurValue = 12700
Field Value
Type
System.Int32

BottomMargin

Specifies the contents of this attribute will contain the bottom page margin in inches.

Declaration
public const string BottomMargin = "b"
Field Value
Type
System.String

Bubble3DTag

This element specifies that the bubbles have a 3-D effect applied to them.

Declaration
public const string Bubble3DTag = "bubble3D"
Field Value
Type
System.String

BubbleChartTag

This element contains the bubble series on this chart.

Declaration
public const string BubbleChartTag = "bubbleChart"
Field Value
Type
System.String

BubbleScaleDefault

Default bubble scale value.

Declaration
public const int BubbleScaleDefault = 100
Field Value
Type
System.Int32

BubbleScaleTag

This element specifies the scale factor for the bubble chart. This element can be an integer value from 0 to 300, corresponding to a percentage of the default size.

Declaration
public const string BubbleScaleTag = "bubbleScale"
Field Value
Type
System.String

BubbleSize

This element specifies the data for the sizes of the bubbles on the bubble chart.

Declaration
public const string BubbleSize = "bubbleSize"
Field Value
Type
System.String

BubbleSizeArea

Specifies the area of the bubbles shall be proportional to the bubble size value.

Declaration
public const string BubbleSizeArea = "area"
Field Value
Type
System.String

BubbleSizeRepresents

This element specifies how the bubble size values are represented on the chart.

Declaration
public const string BubbleSizeRepresents = "sizeRepresents"
Field Value
Type
System.String

BubbleSizeWidth

Specifies the radius of the bubbles shall be proportional to the bubble size value.

Declaration
public const string BubbleSizeWidth = "w"
Field Value
Type
System.String

BuiltInUnitTag

This element specifies the display unit is one of the built in values.

Declaration
public const string BuiltInUnitTag = "builtInUnit"
Field Value
Type
System.String

c14tag

C14 tag

Declaration
public const string c14tag = "c14"
Field Value
Type
System.String

c15tag

C15 tag

Declaration
public const string c15tag = "c15"
Field Value
Type
System.String

CategoryAxisTag

This element specifies a category axis.

Declaration
public const string CategoryAxisTag = "catAx"
Field Value
Type
System.String

CategoryMidpoint

Specifies the value axis shall cross the category axis at the midpoint of a category.

Declaration
public const string CategoryMidpoint = "midCat"
Field Value
Type
System.String

CategoryValuesTag

This element specifies the data used for the category axis.

Declaration
public const string CategoryValuesTag = "cat"
Field Value
Type
System.String

CColorNamespace2013

Declaration
public const string CColorNamespace2013 = "http://schemas.microsoft.com/office/2011/relationships/chartColorStyle"
Field Value
Type
System.String

ChartFormatId

Chart format id

Declaration
public const string ChartFormatId = "fmtId"
Field Value
Type
System.String

ChartPrefix2010

prefix for the Excel 2010 chart tag.

Declaration
public const string ChartPrefix2010 = "c14"
Field Value
Type
System.String

ChartPrefix2016

prefix for the Excel 2016 chart tag.

Declaration
public const string ChartPrefix2016 = "c16"
Field Value
Type
System.String

ChartsheetTag

This is the root element of Sheet Parts that are of type 'chartsheet'.

Declaration
public const string ChartsheetTag = "chartsheet"
Field Value
Type
System.String

ChartSpaceTag

This element specifies overall settings for a single chart, and is the root node for the chart part.

Declaration
public const string ChartSpaceTag = "chartSpace"
Field Value
Type
System.String

ChartStyleTag

This element specifies the style tag.

Declaration
public const string ChartStyleTag = "style"
Field Value
Type
System.String

ChartTag

This element specifies the chart.

Declaration
public const string ChartTag = "chart"
Field Value
Type
System.String

ChartTextTag

This element specifies text to use on a chart, including rich text formatting.

Declaration
public const string ChartTextTag = "tx"
Field Value
Type
System.String

Clustered

Specifies that the chart series are drawn next to each other along the category axis.

Declaration
public const string Clustered = "clustered"
Field Value
Type
System.String

CNamespace

Main charts namespace.

Declaration
public const string CNamespace = "http://schemas.openxmlformats.org/drawingml/2006/chart"
Field Value
Type
System.String

CNamespace2007

Main charts namespace for Excel 2010

Declaration
public const string CNamespace2007 = "http://schemas.microsoft.com/office/drawing/2007/8/2/chart"
Field Value
Type
System.String

CNamespace2016

Main charts namespace for Excel 2016

Declaration
public const string CNamespace2016 = "http://schemas.microsoft.com/office/drawing/2014/chart"
Field Value
Type
System.String

CoordinatesMultiplyer

Multiplier for coordinates transform.

Declaration
public const double CoordinatesMultiplyer = 1000
Field Value
Type
System.Double

CPrefix

Prefix for chart namespace.

Declaration
public const string CPrefix = "c"
Field Value
Type
System.String

CrossAxisTag

This element specifies the ID of axis that this axis crosses.

Declaration
public const string CrossAxisTag = "crossAx"
Field Value
Type
System.String

CrossBetweenTag

This element specifies whether the value axis crosses the category axis between categories.

Declaration
public const string CrossBetweenTag = "crossBetween"
Field Value
Type
System.String

CrossesAtTag

This element specifies where on the axis the perpendicular axis crosses. The units are dependent on the type of axis.

Declaration
public const string CrossesAtTag = "crossesAt"
Field Value
Type
System.String

CrossesAutoZero

The category axis crosses at the zero point of the value axis (if possible), or the minimum value (if the minimum is greater than zero) or the maximum (if the maximum is less than zero).

Declaration
public const string CrossesAutoZero = "autoZero"
Field Value
Type
System.String

CrossesMaximum

The axis crosses at the maximum value

Declaration
public const string CrossesMaximum = "max"
Field Value
Type
System.String

CrossesTag

This element specifies how this axis crosses the perpendicular axis.

Declaration
public const string CrossesTag = "crosses"
Field Value
Type
System.String

CStyleNamespace2013

Chart style relation namespace for Excel 2013

Declaration
public const string CStyleNamespace2013 = "http://schemas.microsoft.com/office/2011/relationships/chartStyle"
Field Value
Type
System.String

CustomUnitTag

This element specifies a custom value for the display unit.

Declaration
public const string CustomUnitTag = "custUnit"
Field Value
Type
System.String

DataLabelPosTag

This element specifies the position of the data label.

Declaration
public const string DataLabelPosTag = "dLblPos"
Field Value
Type
System.String

DataLabelsSeparatorTag

This element specifies text that shall be used to separate the parts of a data label. The default is a comma, except for pie charts showing only category name and percentage, when a line break shall be used instead.

Declaration
public const string DataLabelsSeparatorTag = "separator"
Field Value
Type
System.String

DataLabelsTag

This element serves as a root element that specifies the settings for the data labels for an entire series or the entire chart. It contains child elements that specify the specific formatting and positioning settings.

Declaration
public const string DataLabelsTag = "dLbls"
Field Value
Type
System.String

DataLabelTag

This element specifies a data label.

Declaration
public const string DataLabelTag = "dLbl"
Field Value
Type
System.String

DataPointTag

This element specifies a single data point.

Declaration
public const string DataPointTag = "dPt"
Field Value
Type
System.String

DataTableTag

This element specifies a data table.

Declaration
public const string DataTableTag = "dTable"
Field Value
Type
System.String

DateAxisTag

This element specifies a date axis.

Declaration
public const string DateAxisTag = "dateAx"
Field Value
Type
System.String

DefaultCategoryAxisId

Some category axis id.

Declaration
public const int DefaultCategoryAxisId = 59983360
Field Value
Type
System.Int32

DefaultSecondaryCategoryAxisId

Some secondary category axis id.

Declaration
public const int DefaultSecondaryCategoryAxisId = 62908672
Field Value
Type
System.Int32

DefaultSecondaryValueAxisId

Some secondary value axis id.

Declaration
public const int DefaultSecondaryValueAxisId = 61870848
Field Value
Type
System.Int32

DefaultSeriesAxisId

Some series axis id.

Declaration
public const int DefaultSeriesAxisId = 63149376
Field Value
Type
System.Int32

DefaultValueAxisId

Some value axis id.

Declaration
public const int DefaultValueAxisId = 57253888
Field Value
Type
System.Int32

DeleteTag

This element specifies that the chart element specified by its containing element shall be deleted from the chart.

Declaration
public const string DeleteTag = "delete"
Field Value
Type
System.String

DepthPercentTag

This element specifies the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).

Declaration
public const string DepthPercentTag = "depthPercent"
Field Value
Type
System.String

DisplayBlanksAsTag

This element specifies how blank cells shall be plotted on a chart.

Declaration
public const string DisplayBlanksAsTag = "dispBlanksAs"
Field Value
Type
System.String

DisplayEquation

This element specifies that the equation for the trend line is displayed on the chart (in the same label as the R-squared value).

Declaration
public const string DisplayEquation = "dispEq"
Field Value
Type
System.String

DisplayRSquared

This element specifies that the R-squared value of the trend line is displayed on the chart (in the same label as the equation).

Declaration
public const string DisplayRSquared = "dispRSqr"
Field Value
Type
System.String

DisplayUnitsLabel

Display units label

Declaration
public const string DisplayUnitsLabel = "dispUnitsLbl"
Field Value
Type
System.String

DisplayUnitsTag

This element specifies the scaling value of the display units for the value axis.

Declaration
public const string DisplayUnitsTag = "dispUnits"
Field Value
Type
System.String

DistanceValue

Distance value

Declaration
public const int DistanceValue = 12700
Field Value
Type
System.Int32

DoughnutChartTag

This element contains the doughnut chart series.

Declaration
public const string DoughnutChartTag = "doughnutChart"
Field Value
Type
System.String

DoughnutHoleSizeTag

This element specifies the size of the hole in a doughnut chart group.

Declaration
public const string DoughnutHoleSizeTag = "holeSize"
Field Value
Type
System.String

DownBarsTag

This element specifies the down bars on the chart.

Declaration
public const string DownBarsTag = "downBars"
Field Value
Type
System.String

DropLinesTag

This element specifies drop lines.

Declaration
public const string DropLinesTag = "dropLines"
Field Value
Type
System.String

dXTag

Represents the width or horizontal offset

Declaration
public const string dXTag = "dX"
Field Value
Type
System.String

dYTag

Represents the height or a vertical offset

Declaration
public const string dYTag = "dY"
Field Value
Type
System.String

ErrorBarDirection

This element specifies the direction of the error bars.

Declaration
public const string ErrorBarDirection = "errDir"
Field Value
Type
System.String

ErrorBarMinusTag

This element specifies the error bar value in the negative direction. It shall be used only when the errValType is cust.

Declaration
public const string ErrorBarMinusTag = "minus"
Field Value
Type
System.String

ErrorBarPlusTag

This element specifies the error bar value in the positive direction. It shall be used only when the errValType is cust.

Declaration
public const string ErrorBarPlusTag = "plus"
Field Value
Type
System.String

ErrorBarsNoCap

This element specifies an end cap is not drawn on the error bars.

Declaration
public const string ErrorBarsNoCap = "noEndCap"
Field Value
Type
System.String

ErrorBarsTag

This element specifies error bars.

Declaration
public const string ErrorBarsTag = "errBars"
Field Value
Type
System.String

ErrorBarTypeTag

This element specifies the type of the error bars - positive, negative, or both.

Declaration
public const string ErrorBarTypeTag = "errBarType"
Field Value
Type
System.String

ErrorBarValueTag

This element specifies a value which is used with the Error Bar Type to determine the length of the error bars.

Declaration
public const string ErrorBarValueTag = "val"
Field Value
Type
System.String

ErrorBarValueType

This element specifies the type of values used to determine the length of the error bars.

Declaration
public const string ErrorBarValueType = "errValType"
Field Value
Type
System.String

ErrorBarX

Specifies that error bars shall be shown in the x direction.

Declaration
public const string ErrorBarX = "x"
Field Value
Type
System.String

ErrorBarY

Specifies that error bars shall be shown in the y direction.

Declaration
public const string ErrorBarY = "y"
Field Value
Type
System.String

Filterbarseries

Filter bar series

Declaration
public const string Filterbarseries = "filteredBarSeries"
Field Value
Type
System.String

FilteredAreaSeries

Filtered area series

Declaration
public const string FilteredAreaSeries = "filteredAreaSeries"
Field Value
Type
System.String

FilteredBubbleSeries

Filtered bubble series

Declaration
public const string FilteredBubbleSeries = "filteredBubbleSeries"
Field Value
Type
System.String

FilteredCategoryTitle

Filtered category title

Declaration
public const string FilteredCategoryTitle = "filteredCategoryTitle"
Field Value
Type
System.String

FilteredLineSeries

Filtered line series

Declaration
public const string FilteredLineSeries = "filteredLineSeries"
Field Value
Type
System.String

FilteredPieSeries

Filtered pie series

Declaration
public const string FilteredPieSeries = "filteredPieSeries"
Field Value
Type
System.String

FilteredRadarSeries

Filtered radar series

Declaration
public const string FilteredRadarSeries = "filteredRadarSeries"
Field Value
Type
System.String

FilteredScatterSeries

Filtered scatter series

Declaration
public const string FilteredScatterSeries = "filteredScatterSeries"
Field Value
Type
System.String

FilteredSeriesTitle

Filtered series title

Declaration
public const string FilteredSeriesTitle = "filteredSeriesTitle"
Field Value
Type
System.String

FilteredSurfaceSeries

Filtered surface series

Declaration
public const string FilteredSurfaceSeries = "filteredSurfaceSeries"
Field Value
Type
System.String

Filterseriesuri

Filter series uri

Declaration
public const string Filterseriesuri = "{02D57815-91ED-43cb-92C2-25804820EDAC}"
Field Value
Type
System.String

FirstSliceAngleTag

This element specifies the angle of the first pie or doughnut chart slice, in degrees (clockwise from up).

Declaration
public const string FirstSliceAngleTag = "firstSliceAng"
Field Value
Type
System.String

FloorTag

This element specifies the floor of a 3D chart.

Declaration
public const string FloorTag = "floor"
Field Value
Type
System.String

FooterMargin

Specifies the contents of this attribute will contain the footer margin in inches.

Declaration
public const string FooterMargin = "footer"
Field Value
Type
System.String

FormatCodeAttribute

This element specifies a string representing the format code to apply.

Declaration
public const string FormatCodeAttribute = "formatCode"
Field Value
Type
System.String

Formula

This element specifies a reference to source of the data contained in this chart.

Declaration
public const string Formula = "f"
Field Value
Type
System.String

formulareference

Formual reference

Declaration
public const string formulareference = "formulaRef"
Field Value
Type
System.String

fullReference

Full reference

Declaration
public const string fullReference = "fullRef"
Field Value
Type
System.String

GapDepthTag

This element specifies the space between bar or column clusters, as a percentage of the bar or column width.

Declaration
public const string GapDepthTag = "gapDepth"
Field Value
Type
System.String

GapWidthTag

This element specifies the space between bar or column clusters, as a percentage of the bar or column width.

Declaration
public const string GapWidthTag = "gapWidth"
Field Value
Type
System.String

HeaderMargin

Specifies the contents of this attribute will contain the header margin in inches.

Declaration
public const string HeaderMargin = "header"
Field Value
Type
System.String

HeightModeTag

Represents the layout mode for the height of the element

Declaration
public const string HeightModeTag = "hMode"
Field Value
Type
System.String

HeightPercentTag

This element specifies the height of a 3-D chart as a percentage of the chart width (between 5 and 500).

Declaration
public const string HeightPercentTag = "hPercent"
Field Value
Type
System.String

HeightTag

Represents the height of the element

Declaration
public const string HeightTag = "h"
Field Value
Type
System.String

HiLowLinesTag

This element specifies the high-low lines for the series.

Declaration
public const string HiLowLinesTag = "hiLowLines"
Field Value
Type
System.String

IndexTag

This element specifies the index of the containing element. This index shall determine which of the parent's children collection this element applies to.

Declaration
public const string IndexTag = "idx"
Field Value
Type
System.String

InvertIfNegative

This element specifies the series to invert its colors if the value is negative.

Declaration
public const string InvertIfNegative = "invertIfNegative"
Field Value
Type
System.String

InvertSolidFillFmt

Invert solid fill format

Declaration
public const string InvertSolidFillFmt = "invertSolidFillFmt"
Field Value
Type
System.String

InvertSolidFillFmtUri

Invert solid fill format uri

Declaration
public const string InvertSolidFillFmtUri = "{6F2FDCE9-48DA-4B69-8628-5D25D57E5C99}"
Field Value
Type
System.String

LabelAlignment

Label alignment

Declaration
public const string LabelAlignment = "lblAlgn"
Field Value
Type
System.String

LabelOffsetTag

This element specifies the distance of labels from the axis.

Declaration
public const string LabelOffsetTag = "lblOffset"
Field Value
Type
System.String

LayoutTag

This element specifies how the chart element is placed on the chart.

Declaration
public const string LayoutTag = "layout"
Field Value
Type
System.String

LayoutTargetTag

This element specifies the chart layout target

Declaration
public const string LayoutTargetTag = "layoutTarget"
Field Value
Type
System.String

LeftMargin

Specifies the contents of this attribute will contain the left page margin in inches.

Declaration
public const string LeftMargin = "l"
Field Value
Type
System.String

LeftModeTag

Represents left element for manual layout

Declaration
public const string LeftModeTag = "xMode"
Field Value
Type
System.String

LeftTag

Represents the x location (left) of the chart element as a fraction of width of the chart

Declaration
public const string LeftTag = "x"
Field Value
Type
System.String

LegendEntryTag

This element specifies a legend entry.

Declaration
public const string LegendEntryTag = "legendEntry"
Field Value
Type
System.String

LegendPositionTag

This element specifies the position of the legend.

Declaration
public const string LegendPositionTag = "legendPos"
Field Value
Type
System.String

LegendTag

This element specifies the legend.

Declaration
public const string LegendTag = "legend"
Field Value
Type
System.String

Line3DChartTag

This element contains the 3-D line chart series.

Declaration
public const string Line3DChartTag = "line3DChart"
Field Value
Type
System.String

LineChartTag

This element contains the 2-D line chart series.

Declaration
public const string LineChartTag = "lineChart"
Field Value
Type
System.String

LogarithmicBaseTag

This element specifies the logarithmic base for a logarithmic axis.

Declaration
public const string LogarithmicBaseTag = "logBase"
Field Value
Type
System.String

LogBaseDefault

Default value of the logBase tag.

Declaration
public const int LogBaseDefault = 10
Field Value
Type
System.Int32

LogBaseTag

This element specifies the logarithmic base for a logarithmic axis.

Declaration
public const string LogBaseTag = "logBase"
Field Value
Type
System.String

MajorGridlinesTag

This element specifies major gridlines.

Declaration
public const string MajorGridlinesTag = "majorGridlines"
Field Value
Type
System.String

MajorTickMarkTag

This element specifies the major tick marks.

Declaration
public const string MajorTickMarkTag = "majorTickMark"
Field Value
Type
System.String

MajorTimeUnit

This element specifies the time unit for major tick marks.

Declaration
public const string MajorTimeUnit = "majorTimeUnit"
Field Value
Type
System.String

MajorUnitTag

This element specifies the distance between major ticks.

Declaration
public const string MajorUnitTag = "majorUnit"
Field Value
Type
System.String

ManualLayoutTag

This element specifies how the chart element is placed on the chart manually

Declaration
public const string ManualLayoutTag = "manualLayout"
Field Value
Type
System.String

MarkerSizeTag

This element specifies the size of the marker in points.

Declaration
public const string MarkerSizeTag = "size"
Field Value
Type
System.String

MarkerStyleTag

This element specifies the marker that shall be used for the data points.

Declaration
public const string MarkerStyleTag = "symbol"
Field Value
Type
System.String

MarkerTag

This element specifies a data marker.

Declaration
public const string MarkerTag = "marker"
Field Value
Type
System.String

MaximumTag

This element specifies the maximum value of the axis.

Declaration
public const string MaximumTag = "max"
Field Value
Type
System.String

MaxMinOrientation

Specifies that the values on the axis shall be reversed so they go from maximum to minimum.

Declaration
public const string MaxMinOrientation = "maxMin"
Field Value
Type
System.String

MinimumTag

This element specifies the minimum value of the axis.

Declaration
public const string MinimumTag = "min"
Field Value
Type
System.String

MinMaxOrientation

Specifies that the axis values shall be in the usual order, minimum to maximum.

Declaration
public const string MinMaxOrientation = "minMax"
Field Value
Type
System.String

MinorGridlinesTag

This element specifies minor gridlines.

Declaration
public const string MinorGridlinesTag = "minorGridlines"
Field Value
Type
System.String

MinorTickMarkTag

This element specifies the minor tick marks.

Declaration
public const string MinorTickMarkTag = "minorTickMark"
Field Value
Type
System.String

MinorTimeUnit

This element specifies the time unit for the minor tick marks.

Declaration
public const string MinorTimeUnit = "minorTimeUnit"
Field Value
Type
System.String

MinorUnitTag

This element specifies the distance between minor tick marks.

Declaration
public const string MinorUnitTag = "minorUnit"
Field Value
Type
System.String

MultiLevelStringCacheTag

This element specifies a cache of the labels on the category axis, or the x-values in a bubble or scatter chart.

Declaration
public const string MultiLevelStringCacheTag = "multiLvlStrCache"
Field Value
Type
System.String

MultiLevelStringReferenceTag

This element specifies a reference to data for the category axis (or for the x-values in a bubble or scatter chart)), along with a cache of the last values used.

Declaration
public const string MultiLevelStringReferenceTag = "multiLvlStrRef"
Field Value
Type
System.String

NoMultiLvlLblTag

This element specifies whether multi level labels exists or not

Declaration
public const string NoMultiLvlLblTag = "noMultiLvlLbl"
Field Value
Type
System.String

NumberCacheTag

This element specifies the last numeric data used for a chart.

Declaration
public const string NumberCacheTag = "numCache"
Field Value
Type
System.String

NumberFormatTag

This element specifies number formatting for the parent element.

Declaration
public const string NumberFormatTag = "numFmt"
Field Value
Type
System.String

NumbericValue

Value attribute.

Declaration
public const string NumbericValue = "v"
Field Value
Type
System.String

NumberLiteral

This element specifies a set of numbers used for the parent element.

Declaration
public const string NumberLiteral = "numLit"
Field Value
Type
System.String

NumberReferenceTag

This element specifies a reference to numeric data with a cache of the last values used.

Declaration
public const string NumberReferenceTag = "numRef"
Field Value
Type
System.String

NumericPoint

This element specifies data for a particular data point.

Declaration
public const string NumericPoint = "pt"
Field Value
Type
System.String

OfPieChartTag

This element contains the pie of pie or bar of pie series on this chart.

Declaration
public const string OfPieChartTag = "ofPieChart"
Field Value
Type
System.String

OfPieTypeBar

Specifies that the chart is a bar of pie chart, not a pie of pie chart.

Declaration
public const string OfPieTypeBar = "bar"
Field Value
Type
System.String

OfPieTypePie

Specifies that the chart is pie of pie chart, not a bar of pie chart.

Declaration
public const string OfPieTypePie = "pie"
Field Value
Type
System.String

OfPieTypeTag

This element specifies whether this chart is pie of pie or bar of pie.

Declaration
public const string OfPieTypeTag = "ofPieType"
Field Value
Type
System.String

OverlapTag

This element specifies how much bars and columns shall overlap on 2-D charts.

Declaration
public const string OverlapTag = "overlap"
Field Value
Type
System.String

OverlayTag

This element specifies that other chart elements shall be allowed to overlap this chart element.

Declaration
public const string OverlayTag = "overlay"
Field Value
Type
System.String

PageMarginsTag

This element specifies the page margins for a chart.

Declaration
public const string PageMarginsTag = "pageMargins"
Field Value
Type
System.String

PercentStacked

Specifies that the chart series are drawn next to each other along the value axis and scaled to total 100%.

Declaration
public const string PercentStacked = "percentStacked"
Field Value
Type
System.String

PerspectiveTag

This element specifies the field of view angle for the 3-D chart. This element is ignored if Right Angle Axes is true.

Declaration
public const string PerspectiveTag = "perspective"
Field Value
Type
System.String

Pie3DChartTag

This element contains the 3-D pie series for this chart.

Declaration
public const string Pie3DChartTag = "pie3DChart"
Field Value
Type
System.String

PieChartTag

This element contains the 2-D pie series for this chart.

Declaration
public const string PieChartTag = "pieChart"
Field Value
Type
System.String

PieExplosionTag

This element specifies the amount the data point shall be moved from the center of the pie.

Declaration
public const string PieExplosionTag = "explosion"
Field Value
Type
System.String

PivotFormats

Pivot formats

Declaration
public const string PivotFormats = "pivotFmts"
Field Value
Type
System.String

PivotOptionsTag

Pivot options tag

Declaration
public const string PivotOptionsTag = "pivotOptions"
Field Value
Type
System.String

PivotOptionsTag16

Pivot options tag 16

Declaration
public const string PivotOptionsTag16 = "pivotOptions16"
Field Value
Type
System.String

PivotSourceNameTag

Pivot source name tag

Declaration
public const string PivotSourceNameTag = "name"
Field Value
Type
System.String

PivotSourceTag

Pivot source tag

Declaration
public const string PivotSourceTag = "pivotSource"
Field Value
Type
System.String

Pivoturi

Uri for the pivot chart.

Declaration
public const string Pivoturi = "{781A3756-C4B2-4CAC-9D66-4F8BD8637D16}"
Field Value
Type
System.String

Pivoturi16

Uri for the pivot chart for Excel 2016.

Declaration
public const string Pivoturi16 = "{E28EC0CA-F0BB-4C9C-879D-F8772B89E7AC}"
Field Value
Type
System.String

PlotAreaTag

This element specifies the plot area of the chart.

Declaration
public const string PlotAreaTag = "plotArea"
Field Value
Type
System.String

PlotVisibleOnlyTag

This element specifies that only visible cells should be plotted on the chart.

Declaration
public const string PlotVisibleOnlyTag = "plotVisOnly"
Field Value
Type
System.String

PointCount

This element contains the number of values in the cache.

Declaration
public const string PointCount = "ptCount"
Field Value
Type
System.String

PrintSettings

Print settings

Declaration
public const string PrintSettings = "printSettings"
Field Value
Type
System.String

RadarChartTag

This element contains the radar chart series on this chart.

Declaration
public const string RadarChartTag = "radarChart"
Field Value
Type
System.String

RadarStyleTag

This element specifies what type of radar chart shall be drawn.

Declaration
public const string RadarStyleTag = "radarStyle"
Field Value
Type
System.String

RelativeSizeAnchorTag

This element specifies that the shape described here to reside within a chart should be sized based on relative anchor points.

Declaration
public const string RelativeSizeAnchorTag = "relSizeAnchor"
Field Value
Type
System.String

RichTextTag

This element contains a string with rich text formatting.

Declaration
public const string RichTextTag = "rich"
Field Value
Type
System.String

RightAngleAxesTag

This element specifies that the chart axes are at right angles, rather than drawn in perspective. Applies only to 3-D charts.

Declaration
public const string RightAngleAxesTag = "rAngAx"
Field Value
Type
System.String

RightMargin

Specifies the contents of this attribute will contain the right page margin in inches.

Declaration
public const string RightMargin = "r"
Field Value
Type
System.String

RotationXTag

This element specifies the amount a 3-D chart shall be rotated in the X direction.

Declaration
public const string RotationXTag = "rotX"
Field Value
Type
System.String

RotationYTag

This element specifies the amount a 3-D chart shall be rotated in the Y direction.

Declaration
public const string RotationYTag = "rotY"
Field Value
Type
System.String

RoundedCornersTag

This element specifies the rounded corner tag.

Declaration
public const string RoundedCornersTag = "roundedCorners"
Field Value
Type
System.String

ScalingTag

This element contains additional axis settings.

Declaration
public const string ScalingTag = "scaling"
Field Value
Type
System.String

ScatterChartTag

This element contains the scatter chart series for this chart.

Declaration
public const string ScatterChartTag = "scatterChart"
Field Value
Type
System.String

ScatterStyleTag

This element specifies the type of lines for the scatter chart.

Declaration
public const string ScatterStyleTag = "scatterStyle"
Field Value
Type
System.String

SecondPieSizeTag

This element specifies the size of the second pie or bar of a pie of pie chart or a bar of pie chart, as a percentage of the size of the first pie.

Declaration
public const string SecondPieSizeTag = "secondPieSize"
Field Value
Type
System.String

SeriesAxisTag

This element specifies a series axis.

Declaration
public const string SeriesAxisTag = "serAx"
Field Value
Type
System.String

SeriesLinesTag

This element specifies series lines for the chart.

Declaration
public const string SeriesLinesTag = "serLines"
Field Value
Type
System.String

SeriesOrderTag

This element specifies the order of the series in the collection. It is 0 based.

Declaration
public const string SeriesOrderTag = "order"
Field Value
Type
System.String

SeriesTag

This element specifies a series on a chart.

Declaration
public const string SeriesTag = "ser"
Field Value
Type
System.String

SeriesTextTag

This element specifies text for a series name, without rich text formatting.

Declaration
public const string SeriesTextTag = "tx"
Field Value
Type
System.String

SeriesValuesTag

This element specifies the data values which shall be used to define the location of data markers on a chart.

Declaration
public const string SeriesValuesTag = "val"
Field Value
Type
System.String

ShowBubbleSizeTag

This element specifies the bubble size shall be shown in a data label.

Declaration
public const string ShowBubbleSizeTag = "showBubbleSize"
Field Value
Type
System.String

ShowCategoryTag

This element specifies that the category name shall be shown in the data label.

Declaration
public const string ShowCategoryTag = "showCatName"
Field Value
Type
System.String

ShowExpandCollapseTag16

Show expand collapse tag 16

Declaration
public const string ShowExpandCollapseTag16 = "showExpandCollapseFieldButtons"
Field Value
Type
System.String

ShowHorizontalBorder

This element specifies the horizontal borders shall be shown in a data table.

Declaration
public const string ShowHorizontalBorder = "showHorzBorder"
Field Value
Type
System.String

ShowLeaderLineTag

This element specifies Leader Lines shall be shown in data labels.

Declaration
public const string ShowLeaderLineTag = "showLeaderLines"
Field Value
Type
System.String

ShowLegendKeyTag

This element specifies legend keys shall be shown in data labels.

Declaration
public const string ShowLegendKeyTag = "showLegendKey"
Field Value
Type
System.String

ShowNegativeBubbles

This element specifies negative sized bubbles shall be shown on a bubble chart.

Declaration
public const string ShowNegativeBubbles = "showNegBubbles"
Field Value
Type
System.String

ShowOutline

This element specifies the outline shall be shown on a data table.

Declaration
public const string ShowOutline = "showOutline"
Field Value
Type
System.String

ShowPercentageTag

This element specifies that the percentage shall be shown in a data label.

Declaration
public const string ShowPercentageTag = "showPercent"
Field Value
Type
System.String

ShowSeriesKeys

This element specifies the legend keys shall be shown in a data table.

Declaration
public const string ShowSeriesKeys = "showKeys"
Field Value
Type
System.String

ShowSeriesNameTag

This element specifies that the series name shall be shown in a data label.

Declaration
public const string ShowSeriesNameTag = "showSerName"
Field Value
Type
System.String

ShowValueTag

This element specifies that the value shall be shown in a data label.

Declaration
public const string ShowValueTag = "showVal"
Field Value
Type
System.String

ShowVerticalBorder

This element specifies the vertical border shall be shown in a data table.

Declaration
public const string ShowVerticalBorder = "showVertBorder"
Field Value
Type
System.String

ShowZoneCategoryTag

Show zone category tag

Declaration
public const string ShowZoneCategoryTag = "dropZoneCategories"
Field Value
Type
System.String

ShowZoneDataTag

Show zone data tag

Declaration
public const string ShowZoneDataTag = "dropZoneData"
Field Value
Type
System.String

ShowZoneFilterTag

Show zone filter tag

Declaration
public const string ShowZoneFilterTag = "dropZoneFilter"
Field Value
Type
System.String

ShowZoneSeriesTag

Show zone series tag

Declaration
public const string ShowZoneSeriesTag = "dropZoneSeries"
Field Value
Type
System.String

ShowZoneVisibleTag

Show zone visible tag

Declaration
public const string ShowZoneVisibleTag = "dropZonesVisible"
Field Value
Type
System.String

SideWallTag

This element specifies the side wall.

Declaration
public const string SideWallTag = "sideWall"
Field Value
Type
System.String

SizeValue

Size value

Declaration
public const int SizeValue = 1000
Field Value
Type
System.Int32

SlicerNamespace

Namespace of the slicer

Declaration
public const string SlicerNamespace = "http://schemas.microsoft.com/office/drawing/2010/slicer"
Field Value
Type
System.String

SmoothTag

This element specifies the line connecting the points on the chart shall be smoothed using Catmull-Rom splines.

Declaration
public const string SmoothTag = "smooth"
Field Value
Type
System.String

SourceLinkedAttribute

Indicates whether number format is applied to the axis.

Declaration
public const string SourceLinkedAttribute = "sourceLinked"
Field Value
Type
System.String

SplitPosTag

This element specifies a value that shall be used to determine which data points are in the second pie or bar on a pie of pie or bar of pie chart.

Declaration
public const string SplitPosTag = "splitPos"
Field Value
Type
System.String

SplitTypeTag

This element specifies how to determine which data points are in the second pie or bar on a pie of pie or bar of pie chart.

Declaration
public const string SplitTypeTag = "splitType"
Field Value
Type
System.String

SqureReference

Square reference

Declaration
public const string SqureReference = "sqref"
Field Value
Type
System.String

Stacked

Specifies that the chart series are drawn next to each other on the value axis.

Declaration
public const string Stacked = "stacked"
Field Value
Type
System.String

Standard

Specifies that the chart series are drawn next to each other on the depth axis.

Declaration
public const string Standard = "standard"
Field Value
Type
System.String

StandardFormatAttribute

Represents the standard Number format attribute.

Declaration
public const string StandardFormatAttribute = "Standard"
Field Value
Type
System.String

StockChartTag

This element contains the collection of stock chart series.

Declaration
public const string StockChartTag = "stockChart"
Field Value
Type
System.String

StrikeThroughDouble

A double strikethrough is applied to the text.

Declaration
public const string StrikeThroughDouble = "dblStrike"
Field Value
Type
System.String

StrikeThroughNone

Text is not strike through.

Declaration
public const string StrikeThroughNone = "noStrike"
Field Value
Type
System.String

StrikeThroughSingle

A single strikethrough is applied to the text.

Declaration
public const string StrikeThroughSingle = "sngStrike"
Field Value
Type
System.String

StringCacheTag

This element specifies the last string data used for a chart.

Declaration
public const string StringCacheTag = "strCache"
Field Value
Type
System.String

StringLiteral

This element specifies a set of strings used for the parent element.

Declaration
public const string StringLiteral = "strLit"
Field Value
Type
System.String

StringReferenceTag

This element specifies a reference to string data with a cache of the last values used.

Declaration
public const string StringReferenceTag = "strRef"
Field Value
Type
System.String

Surface3DChartTag

This element contains the set of 3-D surface series.

Declaration
public const string Surface3DChartTag = "surface3DChart"
Field Value
Type
System.String

SurfaceChartTag

This element contains the set of 2-D contour charts.

Declaration
public const string SurfaceChartTag = "surfaceChart"
Field Value
Type
System.String

TextPropertiesTag

This element contains text properties.

Declaration
public const string TextPropertiesTag = "txPr"
Field Value
Type
System.String

TextValueTag

This element specifies a text value for a category axis label or a series name.

Declaration
public const string TextValueTag = "v"
Field Value
Type
System.String

TickLabelHigh

Specifies the axis labels shall be at the high end of the perpendicular axis.

Declaration
public const string TickLabelHigh = "high"
Field Value
Type
System.String

TickLabelLow

Specifies the axis labels shall be at the low end of the perpendicular axis.

Declaration
public const string TickLabelLow = "low"
Field Value
Type
System.String

TickLabelNextTo

Specifies the axis labels shall be next to the axis.

Declaration
public const string TickLabelNextTo = "nextTo"
Field Value
Type
System.String

TickLabelNone

Specifies the axis labels are not drawn.

Declaration
public const string TickLabelNone = "none"
Field Value
Type
System.String

TickLabelPositionTag

This element specifies the position of the tick labels on the axis.

Declaration
public const string TickLabelPositionTag = "tickLblPos"
Field Value
Type
System.String

TickLabelSkip

This element specifies how many tick labels to skip between label that is drawn.

Declaration
public const string TickLabelSkip = "tickLblSkip"
Field Value
Type
System.String

TickMarkCross

Specifies the tick marks shall cross the axis.

Declaration
public const string TickMarkCross = "cross"
Field Value
Type
System.String

TickMarkInside

Specifies the tick marks shall be inside the plot area.

Declaration
public const string TickMarkInside = "in"
Field Value
Type
System.String

TickMarkNone

Specifies there shall be no tick marks.

Declaration
public const string TickMarkNone = "none"
Field Value
Type
System.String

TickMarkOutside

Specifies the tick marks shall be outside the plot area.

Declaration
public const string TickMarkOutside = "out"
Field Value
Type
System.String

TickMarkSkip

This element specifies how many tick marks shall be skipped before the next one shall be drawn.

Declaration
public const string TickMarkSkip = "tickMarkSkip"
Field Value
Type
System.String

TitleTag

This element specifies a title.

Declaration
public const string TitleTag = "title"
Field Value
Type
System.String

TopMargin

Specifies the contents of this attribute will contain the top page margin in inches.

Declaration
public const string TopMargin = "t"
Field Value
Type
System.String

TopModeTag

Represents top element for manual layout

Declaration
public const string TopModeTag = "yMode"
Field Value
Type
System.String

TopTag

Represents the y location (top) of the chart element as a fraction of width of the chart

Declaration
public const string TopTag = "y"
Field Value
Type
System.String

TransparencyValue

Transparency value

Declaration
public const int TransparencyValue = 1000
Field Value
Type
System.Int32

TrendlineBackwardTag

This element specifies the number of categories (or units on a scatter chart) that the trend line extends before the data for the series that is being trended. On non-scatter charts, the value shall be 0 or 0.5.

Declaration
public const string TrendlineBackwardTag = "backward"
Field Value
Type
System.String

TrendlineForwardTag

This element specifies the number of categories (or units on a scatter chart) that the trend line extends after the data for the series that is being trended. On non-scatter charts, the value must be a multiple of 0.5.

Declaration
public const string TrendlineForwardTag = "forward"
Field Value
Type
System.String

TrendlineIntercept

This element specifies the value where the trend line shall cross the y axis. This property shall be supported only when the trend line type is exp, linear, or poly.

Declaration
public const string TrendlineIntercept = "intercept"
Field Value
Type
System.String

TrendlineLabelTag

This element specifies the label for the trend line.

Declaration
public const string TrendlineLabelTag = "trendlineLbl"
Field Value
Type
System.String

TrendlineNameTag

This element specifies the name of the trend line.

Declaration
public const string TrendlineNameTag = "name"
Field Value
Type
System.String

TrendlineOrderTag

This element specifies the order of the polynomial trend line. It is ignored for other trend line types.

Declaration
public const string TrendlineOrderTag = "order"
Field Value
Type
System.String

TrendlinePeriodTag

This element specifies the period of the trend line for a moving average trend line. It is ignored for other trend line types.

Declaration
public const string TrendlinePeriodTag = "period"
Field Value
Type
System.String

TrendlineTag

This element specifies a trend line.

Declaration
public const string TrendlineTag = "trendline"
Field Value
Type
System.String

TrendlineTypeTag

This element specifies the type of the trend line.

Declaration
public const string TrendlineTypeTag = "trendlineType"
Field Value
Type
System.String

UnderlineDouble

Underline the text with two lines of normal thickness.

Declaration
public const string UnderlineDouble = "dbl"
Field Value
Type
System.String

UnderlineSingle

Underline the text with a single line of normal thickness.

Declaration
public const string UnderlineSingle = "sng"
Field Value
Type
System.String

UpBarsTag

This element specifies the up bars on the chart.

Declaration
public const string UpBarsTag = "upBars"
Field Value
Type
System.String

UpDownBarsTag

This element specifies the up and down bars.

Declaration
public const string UpDownBarsTag = "upDownBars"
Field Value
Type
System.String

UserShapesTag

This element specifies the shapes drawn on top of the chart.

Declaration
public const string UserShapesTag = "userShapes"
Field Value
Type
System.String

ValueAttribute

Value attribute.

Declaration
public const string ValueAttribute = "val"
Field Value
Type
System.String

ValueAxisTag

This element specifies a value axis.

Declaration
public const string ValueAxisTag = "valAx"
Field Value
Type
System.String

VaryColorsTag

This element specifies that each data marker in the series shall have a different color.

Declaration
public const string VaryColorsTag = "varyColors"
Field Value
Type
System.String

View3DTag

This element specifies the 3-D view of the chart.

Declaration
public const string View3DTag = "view3D"
Field Value
Type
System.String

WidthModeTag

Represents the layout mode for the width of the element

Declaration
public const string WidthModeTag = "wMode"
Field Value
Type
System.String

WidthTag

Represents the width of the element

Declaration
public const string WidthTag = "w"
Field Value
Type
System.String

WireframeTag

This element specifies the surface chart is drawn as a wireframe.

Declaration
public const string WireframeTag = "wireframe"
Field Value
Type
System.String

xml14web

xml14web

Declaration
public const string xml14web = "http://schemas.microsoft.com/office/drawing/2007/8/2/chart"
Field Value
Type
System.String

xml15web

xml15web

Declaration
public const string xml15web = "http://schemas.microsoft.com/office/drawing/2012/chart"
Field Value
Type
System.String

XTagName

This element specifies the relative x coordinate that is used to define the percentage-based horizontal position for a shape within a chart drawing object.

Declaration
public const string XTagName = "x"
Field Value
Type
System.String

XValues

This element specifies the x values which shall be used to define the location of data markers on a chart.

Declaration
public const string XValues = "xVal"
Field Value
Type
System.String

YTagName

This element specifies the relative y coordinate that is used to define the percentage-based vertical position for a shape within a chart drawing object.

Declaration
public const string YTagName = "y"
Field Value
Type
System.String

YValues

This element specifies the y values which shall be used to define the location of data markers on a chart.

Declaration
public const string YValues = "yVal"
Field Value
Type
System.String

ZoomToFit

Zoom to fit

Declaration
public const string ZoomToFit = "zoomToFit"
Field Value
Type
System.String

Extension Methods